Searches a string for a pattern and replaces it.


RegexpReplace(string, pattern, replacement)

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

NOTE: When the regular expression you want to use contains a slash, quotation or other special character, you will need to use a backslash (\) to escape the special character. Regexp can vary based on the databases. Check the documentation of the database you use to find the correct syntax.


RegexpReplace("277 Main St", "[0-9]+ Main", "345 South")
  • Returns "345 South St"

See Also