The REGEXMATCH() function checks if a text matches a regular expression. It returns a boolean (Vrai or faux) as a checked/unchecked box in boolean format or 1 or 0 in text format.
Useful in input validation, automations, and business rules.
Regex function name :
REGEXMATCH()
Syntax
REGEXMATCH(text, regular_expression)ℹ Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to be added between quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
text |
Text to check. |
regular_expression |
Search pattern used to check if the text matches an expected format. |
Example
Validate a code that contains at least one UPPERCASE letter AND a series of 5 consecutive digits.
REGEXMATCH("reference code T51234", "([A-Z].*([0-9]){5})"Result: true or boolean format 1
REGEXMATCH("reference code T51", "([A-Z].*([0-9]){5})"Result: false or boolean format 0
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.
Notes
- Works only on text.
Returns a boolean (
trueorfalse) as a checked/unchecked box in boolean format or 1 or 0 in text format.-
ℹ️ The character \ and certain shortcuts (\d, \w, \s) are not supported.
See Introduction to REGEX() functions in TimeTonic for the complete usage rules.
Return type
The function returns a boolean.
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula column article.
Text manipulation with Regex
| Function | Action | What is it for? |
|---|---|---|
| REGEXMATCH() | Validate | Check if a text matches a format or rule (returns true or false). |
| REGEXEXTRACT() | Extract | Retrieve specific information contained in unstructured text. |
| REGEXREPLACE() | Clean / transform | Dynamically replace or remove parts of a text according to a pattern. |