> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/find-and-replace.md).
# Use Find and Replace
Use the **Find and Replace** transformation to search for values within one or more columns and replace them with new values. Use this transformation to standardize dimension members, simplify reporting categories, and clean source data before loading it into a planning sheet or report.
The following examples demonstrate how to use **Find and Replace** on the **Market & Geography** column.
### Replace a text value
In this example, the **Market & Geography** column contains values such as *Channel Partners,Canada*, *Enterprise,Canada*, and *Government,Canada*.
To replace all occurrences of **Canada** with **CA**:
1. On the **Transform** tab, select **Find and Replace**.
2. In **Target Columns**, select **Market & Geography**.
3. In **Find**, enter **Canada**.
4. Select **Fuzzy Match**.
5. In **Replace With**, enter **CA**.
6. Select **Apply**.
After you apply the transformation, the **Market & Geography** column uses the abbreviated country code.
### Replace values by using a regular expression
Use regular expressions to replace multiple matching values with a single standardized value.
In this example, you group all values in the **Market & Geography** column that end with **CA** into a single category called **Canada Market**.
1. On the **Transform** tab, select **Find and Replace**.
2. In **Target Columns**, select **Market & Geography**.
3. In **Find**, enter `.*,CA$`.
4. Select **Use Regular Expression**.
5. In **Replace With**, enter **Canada Market**.
6. Select **Apply**.
The regular expression `.*,CA$` matches any value that ends with **CA**.
After you apply the transformation, all matching values appear as **Canada Market**.
### Match case options
The **Find and Replace** transformation supports the following matching methods:
* **Fuzzy Match**: Finds values that approximately match the search text.
* **Fuzzy Case Match**: Finds approximate matches while considering letter casing.
* **Match Full String**: Replaces values only when the entire value matches the search text.
* **Use Regular Expression**: Uses regular expression patterns to identify matching values.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/find-and-replace.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
