fbpx
Select Page

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 slash (/) 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.

Examples

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

See Also

RegexpMatch
RegexpExtract

More About Text Functions

Text functions analyze or manipulate string data and are useful sanitizing string input.

When inputting a string, use quotation marks to indicate it as a string. “This is read as a string”

If you would like to include quotes in your string, you can use a slash \ to indicate the following quote is part of the string. “\”This is a string with quotes\”” will display as “This is a string with quotes”

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.