INITCAP
Returns a string with the first letter of each blank-delimited word capitalized. Enrichment does not change words that contain non-alphabetic characters.
Syntax
INITCAP(string)
Arguments
Argument | Description | Default |
---|---|---|
string | The string to capitalize. | None |
Results
Result | Description |
---|---|
Return | string with words capitalized as appropriate. |
%%RC | Always set to 0. |
%%RM | A null string (''). |
%%RV | Always set to 0. |
Examples
Note: In the first example, the
street
in street
was not capitalized because it contained a non-alphabetic character (,).Function Call | Return |
---|---|
INITCAP('100 12th street, LEX KY 40513 U.S.A') | '100 12th street, Lex Ky 40513 U.S.A' |
INITCAP('amount due: $1,245') | 'Amount due: $1,245' |