(string Value, string Pattern)
Evaluates a regular expression on a value parameter and replaces the matches with empty string.
Example: REGEXREPLACE("Some text", "text") evaluates the regular expression and returns the
result (Some ).
Value: Required. Text in which you want to replace characters.
(string Value, string Pattern, string replacement)
Evaluates a regular expression on a value parameter and replaces the matches with empty
replacement parameter.
Example: REGEXREPLACE("Some text", "text", "other text") evaluates the regular expression and
returns the result (Some other text).
Value: Required. Text in which you want to replace characters.
Example 1
Remove the dash from "CPR":
regexreplace(&CPR,"-")
Example 2
Replace "Person" with "Employee":
regexreplace(&Name,"Person","Employee")
Comments
Please sign in to leave a comment.