LOWER Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=LOWER function |titlemode=append |keywords=planfix, function, LOWER |description=LOWER function }} The LOWER() function converts the characters in a text string from uppercase to lowercase. == Format == *'''LOWER('''text''')''' The '''text''' argument is mandatory and is converted to lowercase. The function LOWER does not replace characters that are not letters. == Examples == {| class="wikitable" |- ! style="font-weight: bold" | Formula ! style="font...") |
No edit summary |
||
(One intermediate revision by one other user not shown) | |||
Line 12: | Line 12: | ||
The '''text''' argument is mandatory and is converted to lowercase. The function LOWER does not replace characters that are not letters. | The '''text''' argument is mandatory and is converted to lowercase. The function LOWER does not replace characters that are not letters. | ||
== Examples == | == Examples == | ||
Line 32: | Line 31: | ||
== Go To == | == Go To == | ||
*[[Standard functions| | *[[Standard functions | Standard operators and Planfix functions]] | ||
*[[Calculated fields]] | |||
*[[Reports]] |
Latest revision as of 14:12, 15 February 2024
The LOWER() function converts the characters in a text string from uppercase to lowercase.
Format
- LOWER(text)
The text argument is mandatory and is converted to lowercase. The function LOWER does not replace characters that are not letters.
Examples
Formula | Description | Result |
---|---|---|
LOWER("A.M.Wilson") | Returns the text in lowercase letters | a.w.wilson |
LOWER({{Task.Name}}) | Returns the text of the variable in lowercase letters | task name |