> For the complete documentation index, see [llms.txt](https://docs.inforiver.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/find-and-replace.md).

# Find and Replace

As the name implies, the Find and Replace option searches a particular dimension column for a string or value and replaces it with the given string. Let's consider a Global market report to demonstrate this.

<figure><img src="/files/umuwN9HhdpqOdhk1d0Gj" alt=""><figcaption><p>Sample report</p></figcaption></figure>

We'll look at the inputs required to replace the "Bovespa Index" benchmark with "S\&P 500" in the Benchmark column.

<figure><img src="/files/cpig4U9CVQUeIf4RP3eP" alt=""><figcaption><p>Find and Replace configuration</p></figcaption></figure>

* **Target columns:** You can select one or more columns from the dropdowns. These columns will be searched and replaced with the given value if the search string is found.
* **Find**: The string to search for.
* **Match Case:** You can opt for a fuzzy match, exact match or even provide a regular expression. Let's use a regex to replace all the Benchmarks that contain "Bovespa Index".

<figure><img src="/files/FDGqy5lV3bcI6ibc8HyJ" alt=""><figcaption><p>Find and replace with regular expressions</p></figcaption></figure>

* **Replace with:** The new string/value that will replace the search string.


---

# 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:

```
GET https://docs.inforiver.com/infobridge-wb-matrix-only/9.-data-transformations/find-and-replace.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.