Change case within string

[cathyg18]

I am using Crystal 7 (hello from the dark ages!).

I have data stored in a table in all upper case. I want to display the data with each word beginning in upper case, the remainder in lower case.

Example:

Data: THIS IS MY DATA
Display: This Is My Data

How can I do this?

Thanks,

Cathy

 

[synapsevampire]

There's a UFL (user Function Library from Crystal for CR 7 and below:

http://support.businessobjects.com/communityCS/FilesAndUpdates/uflcaps.exe.asp

-k

 

[cathyg18]

Fabulous! Thank you.