Initial Caps Formula

[Jefftopia]

Is there a function to convert text to initial caps?

For example: The string "EAT MY SHORTS" would be converted to "Eat My Shorts".

 

[vidru]

If you've got Crystal 9, there should be a ProperCase function that does what you're looking for.

Here's the KB article:

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

If you don't have 9, there's a LeadingCaps UFL that you can get here:

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

-dave

 

[Turkbear]

Hi,
If you can edit your Sql, and your Database supports it, you can use a function ( in Oracle it is

InitCap(field_name)

Your results may vary, depending on your Database's syntax.