Format of data in Merge Documents

denisv

In a merge document is it possible to format the data merged to use UpperCase. Sometimes data is entered by users in all lower or all upper case.

aware_support

You can use TO_UPPER_CASE function for that.

denisv

Thanks I will try that.

If I have a Timestamp field is it possible only to display the date in the merge value instead of the full timestamp value ?

tford

If I have a Timestamp field is it possible only to display the date in the merge value instead of the full timestamp value ?

Seems like you should be able to us the DATE_PART function.

Tom[/quote]

denisv

Thanks Tom that worked fine.

I am still a bit stuck on the upper case however as it is not full upper case I need but leading caps, so for example leading caps would become Leading Caps.

Is there a function or combination of functions that can achieve this ?Thanks

tford

I need but leading caps, so for example leading caps would become Leading Caps

Have you tried Googling on Regular Expressions (which AwareIM can utilize) and leading caps?

There is not an function provided that simply provides leading caps.

Tom