The RegExReplace() function replaces all matches for Pattern in SourceText, and replaces them with the ReplaceText value.
All regex functions use a pattern to check for matches in the input text.
For a more complete explanation and special / allowed characters you can visit this WEM Forum post. Here you find a cheat-sheet and a few helpful examples.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns SourceText with the matching patterns replaced by the replace-text value.
Returns SourceText if no matches are found or the pattern is faulty.
| Name | Type | Required | Description |
|---|---|---|---|
pattern
text
The pattern you want to replace.
sourcetext
text
The text you want to check for patterns to replace.
replacetext
text
The text you want to replace the pattern with.