Function: RegexReplace

DESCRIPTION

Scans the given string for matches to the given regular expression pattern and replaces the matching string.

SYNTAX

RegexReplace(string,pattern,replacement)

ARGUMENTS

string refers to the input text.

pattern refers to the regex pattern to match.

RETURN VALUE

Each match found is replaced according to the substitution indicated in the replacement string and the overall resultant string is returned.

EXAMPLE

The expression RegexReplace([Department],"[A-Z]{1}[a-z]+","Call ") will replace all entries marked "Data Processing" in the Department field with "Call Processing."