Format of data in Merge Documents

denisv · Post by **denisv** » Tue Oct 21, 2008 8:20 am

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 · Post by **aware_support** » Tue Oct 21, 2008 10:48 am

You can use TO_UPPER_CASE function for that.

denisv · Post by **denisv** » Wed Oct 22, 2008 8:25 am

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 · Post by **tford** » Wed Oct 22, 2008 12:23 pm

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 · Post by **denisv** » Wed Oct 22, 2008 1:35 pm

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 · Post by **tford** » Fri Oct 24, 2008 5:40 am

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