This article covers a few ways that you can change the look of the text string using the following functions:
This article is part of a guided course which you can view here.
LOWER() and UPPER()
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. On their own, these functions can help you keep text consistently in the case you need.
Their functionality is vert straightforward:
LOWER("The dog is a Good Boy.")produces the following result:
the dog is a good boy.
Alternatively, replacing LOWER with UPPER accomplishes the opposite result:
THE DOG IS A GOOD BOY.
Naturally, you can use a field name for more dynamic results:
TRIM function serves a singular purpose: to remove white space from a string of text. Let's see what that looks like in action:
TRIM("Ada Lovelace") results in AdaLovelace.`
Sometimes you need to remove whitespace when creating username variants of a person's full name, make text more URL-friendly, remove spaces from a long number so you can work with it as a number (rather than text), or any other situation where you need to get rid of spaces.
TRIM will take care of that automatically on its own.
The function works similarly with a field as an input:
The results will include the contents of the text field in each record without whitespace.
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 spaces you can use this formula:
This article is part of a guided course that helps you learn how to use Airtable formulas.