RegexpReplace

Searches a string for a pattern and replaces it.

Usage

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.

Example

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

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us