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.