RegexpReplace

The RegexpReplace function searches a string for a pattern and replaces all matches with the replacement string. If no matches are found, the original string is returned.

RegExpReplace can be useful for complex text pattern matching, or matching multiple patterns at once. For one-to-one text replacements, the Replace function may also be useful.

Syntax

RegexpReplace(string, pattern, replacement)

Function arguments:

• string (required): The string to search.
• pattern (required): The pattern to extract with.
• replacement (required): String to replace the sought pattern.

📘

When your regular expression statement contains a slash, quotation or other special character, use a backslash () to escape the special character. Regexp can vary by database.

Notes

• When any of the arguments are Null, the function returns Null.
• Regular expressions vary by database. Check the documentation of your data platform for syntax.

Examples

RegexpReplace([Product Name], "(\\d+) (\\d+mm)", "\\1-\\2")

Replaces every space between digits and digits preceding "mm" with a dash to indicate the range of camera lenses.

RegexpReplace([Phone Number], "(\\d{3})(\\d{3})(\\d{4})", "(\\1) \\2-\\3")

Transforms a phone number to (xxx) xxx-xxxx formatting.

RegexpReplace([City], "^(.*?),", "San Francisco,")

Replaces every character before the comma with the city in proper form.

RegexpReplace([Team], "[^a-zA-Z0-9\\s]", "")

Removes all punctuation marks in a string.

RegexpReplace([Text], "\\/", "&")

Replaces the slash with "&".