The REGEXMATCH() function checks whether a text matches a regular expression. It returns a boolean (true or false): a checked/unchecked checkbox in boolean format, or 1 or 0 in text format. Useful for input validation, automations and business rules.
The output format of the result is configured in the output field options of the formula editor: see Formula column.
Syntax
REGEXMATCH(texte, expression_régulière)
How to reference parameters in TimeTonic: $field_name for a field (link, linked-table column, number, selection, formula, text); "free text" in quotes; no quotes for numbers.
Parameters
Example
Validate a code containing at least one uppercase letter and a run of 5 consecutive digits
"code de référence T51234" becomes "true" (or 1 in boolean format).
REGEXMATCH("code de référence T51234", "([A-Z].*([0-9]){5})"
"code de référence T51" becomes "false" (or 0 in boolean format).
REGEXMATCH("code de référence T51", "([A-Z].*([0-9]){5})"
What it does:
- [A-Z] → at least one uppercase letter.
- * → anything in between.
- ([0-9]){5} → 5 consecutive digits.
The result returns true if both conditions are present in the text, otherwise it returns false.
Works on text only. Returns a boolean (true or false): a checked/unchecked checkbox in boolean format, or 1 or 0 in text format. The \ character and some shortcuts (\d, \w, \s) are not supported.
See Introduction to REGEX() functions in TimeTonic for the complete usage rules.
Manipulating text with Regex
Go further
REGEXREPLACE()
Dynamically replaces or removes parts of a text according to a pattern.
Or continue with
Formula glossary
All available operators and functions, sorted by category.