> 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/replace.md).

# Replace

Finds the specified substring(s) and replaces it with the new text

```mathematica
Replace("The River", "i", "o") → "The Rover"
Replace("Netherland", "Ne", "Mo") → "Motherland"
```

#### Inputs

`Replace(string, search, replacewith, [isCaseSensitive], [allMatches])`

* `string` - A text value to search in
* `search` - Text 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