PROPER Function: Difference between revisions
From Planfix
No edit summary |
No edit summary Tag: Reverted |
||
Line 34: | Line 34: | ||
*[[Standard functions | Standard operators and Planfix functions]] | *[[Standard functions | Standard operators and Planfix functions]] | ||
*[[Calculated fields]] | *[[Calculated fields]] | ||
Revision as of 10:39, 4 December 2024
The function PROPER () works as follows: the first letter in a text string and all first letters following non-letter characters are converted to uppercase (upper case). All other letters in the text are converted to lowercase (lower case).
Format
- PROPER(text)
The text argument is mandatory. Text in quotes, a formula that returns text in which some letters need to be replaced with uppercase.
Examples
Formula | Description | Result |
---|---|---|
PROPER("this is a TITLE") | Corrected case of the string | This Is A Title |
PROPER({{Name.Task}}) | Corrected case of the string | Task Name |
PROPER("76BuDGet") | Corrected case of the string | 76Budget |