> For the complete documentation index, see [llms.txt](https://docs.tabula.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tabula.io/data-transformation/formulas/string-functions/replaceregexp.md).

# ReplaceRegexp

Finds the specified regular expression pattern and replaces it with the new text

```mathematica
ReplaceRegexp("price 100 EUR", "EUR|GBP", "USD") → "price 100 USD"
ReplaceRegexp("1999", "[9]", "0") → "1000"
```

#### Inputs

`ReplaceRegexp(string, searchRegexp, replaceWith, [isCaseSensitive], [allMatches])`

* `string` - A text value to search in
* `searchRegexp` - Regular expression to search for
* `replaceWith` - Text to replace with
* `[isCaseSensitive]` - **\[optional**: `true` by default\*\*]\*\* - Set `false` if search should be case **insensitive**
* `[allMatches]` - **\[optional**: `true` by default\*\*]\*\* - Set `false` if only the first match should be replaced