> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Replace

> Use the Sigma Replace function to search through a input string for a substring and replace every instance of it with a replacement string.

The **Replace** function searches through a input string for a substring and replaces every instance of it with a replacement string.

This is useful for standardizing alternative abbreviations and names, fixing common misspellings, changing one delimiter for another, and selectively removing particular substrings. For more complex pattern matching, or to match multiple patterns at once, the **[RegExReplace](/docs/regexpreplace)** may be useful.

## Usage

```
Replace(string, substring, replacement)
```

**string** (required)- String to be searched and modified.

**substring** (required)- Substring to be found and replaced.

**replacement** (required)- String to replace the substring.

## Examples

```
Replace("SF County","SF","San Francisco")
```

* Returns: "San Francisco County"

`Replace("File Name"," ","")`

* Returns: "FileName"
* Using an empty string as your replacement string allows you to remove every instance of the substring

```
Replace(Replace([Order Manual], "Cold Slaw", "Cole Slaw"), "Ice Tea", "Iced Tea")
```

* When applied to the \[Order Replaced] column, returns:

![](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/547d19a46dd534e7f207ba60228c484bfa8d50563b37feedcd185b055280610c/assets/docs-images/1d204b7-mceclip0.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260727%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260727T220249Z&X-Amz-Expires=604800&X-Amz-Signature=1efaf264f64a8ef0b9fe8aa26befe9fbd0adf4dfc103edf2bb06aec9a219f094&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

## Related resources

* [Find](/docs/find)