Makes string uppercase.
Makes a string lowercase.
Returns the length of a string.
Joins together the text arguments into a single text value.
To concatenate static text, surround it with double quotation marks. To concatenate double quotation marks, you need to use a backslash (\) as an escape character.
Repeats string by the specified number of times.
Removes whitespace at the beginning and end of string.
Extract howMany characters from the end of the string.
Extract a substring of count characters starting at whereToStart.
Finds an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition.(startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be 0.
Similar to SEARCH(), though SEARCH() returns empty rather than 0 if no occurrence of stringToFind is found.
Searches for an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition. (startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be empty.
Replaces occurrences of old_text with new_text.
You can optionally specify an index number (starting from 1) to replace just a specific occurrence of old_text. If no index number is specified, then all occurrences of old_text will be replaced.
Replaces the number of characters beginning with the start character with the replacement text.
Returns the argument if it is text and blank otherwise.
Replaces certain characters with encoded equivalents for use in constructing URLs or URIs. Does not encode the following characters: - _ . ~
Create a line break when inserted between other text in a formula.
Concatenate text values into a single text value.
Smart quotes (“”)
appear curved and will cause an error in Airtable. Instead, use only straight-lined quotes within formulas.