The question is, is the following task beyond the scope of F&R (&/or MS)?
Basically:-
I have .xml's that need search & replace operations.
I need to check
multiple files for
each of the entries & replace if/where found.
All SAR terms are
not in all files... Both searches & replacements will change over time.
The source for the search & the replacements is currently a CSV, >1000 rows/entries.
The job is thus:-
Search for x where x is entry in CSV column 1;
If CSV column 1 entry found, replace with CSV column 2 entry; (Rows being SAR pairs 1|1, 2|2, 3|3 etc)
OR
If CSV column 1 entry not found;
Step down to next row, loop til end of CSV
Resulting XML to be saved with a new name
Next file
So far in F&R I tried adding all column 1 entries to
find & all column 2 entries to
replace with "Find many, Replace with many" selected.
Result is
error 87 see screen.
I'm guessing this is because there are mismatches & F&R doesn't step down to next term rather than there being too many entries.....?
...........Maybe I can leverage F&R with MS or something?
Any simple way to do this task? Thanks in advance