PROPER Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=PROPER Function |titlemode=append |keywords=planfix, function, PROPER |description=PROPER Function }} 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 ret...") |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 8: | Line 8: | ||
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). | 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 == | == Format == | ||
*'''PROPER('''text''')''' | *'''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. | The '''text''' argument is mandatory. Text in quotes, a formula that returns text in which some letters need to be replaced with uppercase. | ||
== Examples == | == Examples == | ||
| Line 38: | Line 35: | ||
== Go To == | == Go To == | ||
*[[Standard functions]] | *[[Standard functions | Standard operators and Planfix functions]] | ||
*[[Calculated fields]] | |||
*[[Reports]] | |||
Latest revision as of 14:13, 15 February 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 |