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.

Sample report

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

Find and Replace configuration

• 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".

Find and replace with regular expressions

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