RegExMatches

The RegExMatches() checks a text for patterns and returns all matching results.

All regex functions use a pattern to check for matches in the input text.

For a more complete explanation and special / allowed characters you can visit this WEM Forum post. Here you find a cheat-sheet and a few helpful examples.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns an array of all matching values. Returns Invalid expression if no matches are found or the pattern is faulty.

Syntax

RegExMatches(pattern, text)

RegExMatches("\\b\\w+es\\b", "There are matches in this line, but who writes these notes anyway?") => "matches, writes, notes"

Parameters

Name	Type	Required	Description
pattern	text	☑️	The pattern you want to check for.
text	text	☑️	The text you want to check for patterns.