PROPER Function: Difference between revisions

From Planfix
Jump to: navigation, search
(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...")
 
Line 38: Line 38:


== Go To ==
== Go To ==
*[[Standard functions]]
*[[Standard functions | Standard operators and Planfix functions]]
*[[Calculated fields]]
*[[Reports]]

Revision as of 14:38, 7 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


Go To