how to create a Sentence Case formula? 1

[yehong]

Is there a way to create a Sentence Case formula in Crystal?
I have a string and text is separted by spaces. e.g, "my name is abc". I want to convert it to "My Name Is Abc".

thanks

 

[MJRBIM]

This is now a CRYSTAL FUNCTIONS - you can use the function and save you the "Manual" formula work.

Info can be found on the CD site for version 9

http://support.crystaldecisions.com/library/kbase/articles/c2011637.asp

and earlier versions (pre-9)

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

Hope it helps...

 

[yehong]

Thanks! This is what I needed.