Skip to main content
Video tutorials
TimeTonic GPT
Log in
EN
FR
Français
EN
English
Navigation
Video tutorials
TimeTonic GPT
Log in
Language
FR
EN
Account
Search
Let us guide you!
TimeTonic Help Center
Formulas
Functions
Text functions
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)