=REGEXFIND
The REGEXFIND function uses a Regular Expression to locate and return text that matches a specified pattern within a string. It can also be combined with other functions to extend its capabilities.
Syntax
Section titled “Syntax”=REGEXFIND(RegEx; StringToSearch)Parameters
Section titled “Parameters”RegEx – The regular expression pattern used to search for matching text.
StringToSearch – The text string or field token that will be searched.
How It Works
Section titled “How It Works”-
Applies the provided regular expression to the input text.
-
Searches for the first matching pattern within the string.
-
Returns the matching text found.
-
Can be nested inside other functions to enhance text extraction and transformation workflows.
Usage Notes
Section titled “Usage Notes”-
Formula functions are case sensitive and must be written in ALL CAPS.
-
Requires valid regular expression syntax for accurate results.
-
Commonly used for extracting numbers, patterns, IDs, or structured text fragments.
-
Can be combined with functions like LEFTOF, RIGHTOF, PARSE, or other text functions.
-
Returns only the matched portion of the string, not the full input.
Examples
Section titled “Examples”=REGEXFIND(\d+; This regex will find this number: 263)Returns
Section titled “Returns”263Example 2 (with nested function usage)
Section titled “Example 2 (with nested function usage)”Given:
[[Field Token]] = There are 487 widgets.
Formula:
=RIGHTOF(=REGEXFIND(\d+; [[Field Token]]); [[Field Token]])Returns
Section titled “Returns”widgets.Keywords
Section titled “Keywords”REGEXFIND, regular expression, regex match, extract pattern, text search, numeric extraction, nested functions, workflow formulas, formula function