Modify Filter value in Report

Question

Hi All,

I have a requirement to modify the filter, BINNED, and prompted particular value.

Like replace "ABC" with "XYZ" in all reports where ABC is used as the filter, BINNED, and prompted.

We have more than 5000 reports and 1500 reports might have ABC used as filter or in BIN section  or Prompt.

Using XML search and replace we may be able to search and modify one file at a time, using Notepad ++ ,, but there is a danger we may change the folder name or title or column name it self which we dont want to.

Please let us know if any one performed this activity and provide steps.

Thanks

[Deleted User] · Answer

+1 to Gianni. XMLSearch&Replace can do that for the whole catalog as well, not just object by object

Gianni Ceresa · Answer

Hi,

"XML Search and Replace" in Catalog Manager is what you look for as it will do all the job in one step (ok, maybe 2 or 3 for safety...).

Of course do not try to be smarter than what the tool is, doing a "search for 'ABC' and replace by 'XYZ' " because as you said it will replace it everywhere without really looking at what is ABC.

It's up to you to define the good search syntax, so searching for more than just ABC but maybe looking for a longer string which will clearly identify and match only the required things (and here is why I said 2 or 3 steps for safety as you better want to first look to replace only filters etc. by using a really strong matching string).