@ProperCase (Formula Language)
Converts the words in a string to proper-name capitalization: the first letter of each word becomes uppercase, all others become lowercase.
Syntax
@ProperCase( string )
Parameters
string
Text or text list. The string you want to convert.
Return value
properString
Text or text list. The string, converted to proper-name capitalization.
Usage
If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.
A "word" is a consecutive set of characters with no spaces. Hyphenated words are considered two words, as are words separated by any other punctuation except an apostrophe.
Examples
- This example returns Every Child Loves Toys.
@ProperCase("every CHILD LOves toys") - This example returns 3-Digit Code.
@ProperCase("3-digit code") - This example returns Los Angeles if the string in the field named
City contains the string los angeles, Los Angeles, LOS ANGELES, los
Angeles, or any other variation.
@ProperCase(City) - This example returns Robert and Smith in a list.
@ProperCase("ROBERT" : "SMITH")