Convert CAPS to lower case

[ddnh]

I have some text fields with data in all CAPS. Is there a formula I can use to convert them to lower case?

Existing data: SEE THE CAT
Convert to: See the cat

I'm using CR 10

 

[synapsevampire]

You don't want lower case, you want mixed case (or termed propercase in Crystal).

There's a function called PROPERCASE().

-k

 

[bdreed35]

To convert to all lowercase, use the lowercase function:

lowercase({table.field})

There is also a propercase function:

propercase({table.field})

~Brian

 

[ddnh]

thanks! That was fast!