propercase(X)
Returns the given string with the first letter, as well as any other letter that follows any character other than a letter, capitalized, and converts all other letters to lower case.
(Available as of version 14.21)
Syntax
propercase(X)Input
| Argument | Type | Description |
|---|---|---|
X |
text | A scalar value or the name of a column |
Return Value
Returns the text value corresponding to X with the first letter, and any other
letters in text that follow any character other than a letter, capitalized. All other
letters are converted to lower case.
If X is N/A, then the result is N/A.
Sample Usage
value |
propercase(value) |
|---|---|
| 'BAnaNA' | 'Banana' |
| 'THE most-interesting Man' | 'The Most-Interesting Man' |
Additional Information
propercaseis Unicode (UTF-8) compliant and will work with Unicode or plain ASCII text fields. (Available as of version 14.25)propercaseis similar to the proper() function in Excel.