Function: RegexExtract

Description

Scans the given string for matches to the given regular expression pattern and extracts a specified portion of the string.

Syntax

RegexExtract(string,pattern,[N])

Arguments

string refers to the input text.

pattern refers to the regex pattern to match.

Return Value

The text of the Nth match found. If N is not given, this function returns the text of the first match found, if any.

example

To extract the word "Processing" from all entries marked "Data Processing" in the Department field, the following expression can be used:

RegexExtract([Department],"[A-Z]{1}[a-z]+",2)