=LISTITEMREGEX
The =LISTITEMREGEX() function loops over a semicolon separated text list and returns only the list entries that pass the regular expression (regex).
Syntax
Section titled “Syntax”=LISTITEMREGEX(RegEx; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
RegEx – The regular expression pattern to match against each list entry.
-
SemicolonSeparatedList – The semicolon-separated list of text values to evaluate.
How It Works
Section titled “How It Works”-
Evaluates each item in the provided list.
-
Returns only the entries that match the regular expression.
Usage Notes
Section titled “Usage Notes”- Formula functions are case sensitive and must be written in ALL CAPS.
Example
Section titled “Example”=LISTITEMREGEX(.*Entry\d; ListEntry1; Entry2; FindText3; FindText4; LastEntry5)Returns
ListEntry1; Entry2; LastEntry5
Keywords
Section titled “Keywords”LISTITEMREGEX, regex match, regular expression, list filtering, semicolon-separated list, string pattern, workflow formulas, formula function