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