Function: RegexSplit
Description
Scans the given string for matches to the given regular expression pattern and splits the string.
Syntax
RegexSplit(string,pattern,[piece])
Arguments
string refers to the input text.
pattern refers to the regex pattern to match.
Return value
Returns the requested piece counting from the left. Returns the first piece if piece is not specified.
Example
The expression RegexSplit([Department],"[A-Z]{1}[a-z]+",2) will return the word "Processing" from all entries marked "Data Processing" in the Department field.
© 2024 Altair Engineering Inc. All Rights Reserved.