In this article we will learn how you can change the look of a text string using the text functions: LOWER, UPPER, TRIM.
1. LOWER
2. UPPER
3. TRIM
LOWER() and UPPER()
The LOWER function takes a string of text and makes all the characters lowercase. Conversely, UPPER changes all characters in a string of text to uppercase.
Here, example: LOWER(“Is it a Holiday Today?”)
Result : is it a holiday today?
Alternatively, replacing LOWER with UPPER accomplishes the opposite result: IS IT A HOLIDAY TODAY?
TRIM()
The TRIM function serves a singular purpose: to remove blank space from the beginning and end of a string. Let's see what that looks like in action:
Result: is it a holiday today ???
Combined with other functions, TRIM can help you accomplish more.
For example, if you want a character count for a text field but don't want to count blank spaces at the beginning and/or end, then you can use this formula:
Result: 22
If you wanted to remove all of the blank spaces from a string, then another formula would work better in this instance.
Result: is-it-a-holiday-today?