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)
© 2024 Altair Engineering Inc. All Rights Reserved.