Text functions
- SUBSTR() : extract part of a text (substring)
- LOWER() : convert text to lowercase
- UPPER() : convert text to uppercase
- REGEXEXTRACT() : extract text with a regular expression (regex)
- REGEXREPLACE() : replace text with a regular expression (regex)
- REGEXMATCH() : test text against a regular expression (regex)
- TRIM() : remove leading and trailing spaces
- LENGTH() : count the number of characters in a text
- SEARCH() : find the position of a text (case-insensitive)
- FIND() : find the position of a text (case-sensitive)
- LEFT() : extract the first characters of a text
- RIGHT() : extract the last characters of a text
- REPLACE() : replace part of a text by position
- SUBSTITUTE(): Replace text with another (substitution)
- READ_DATE() : convert text to a date (PARSEDATE)
- FORMAT_NUMBER() : format a number (decimals, leading zeros, ID)
- FORMAT_DATE(): Convert a Date to Formatted Text
- HTML_TO_TEXT() : convert HTML to plain text
- TEXT_DAY() : display the day of the week of a date
- EXTRACT_ELEMENT() : extract an element from a list (first, last)
- APPLY_MASK(): Apply a Mask to Text (Format a Number)