DosTips.com

Search using terms - replace string find file - was not successful as to many common words but this is exactly what I am needing.

Task, I need to search and replace in a file (2 actually) using a series of values that I will have in a delimited file stored as Old,New format.
I have this script that will read a file, parse and return the old and new values as variables.


Input


Ouput shown below

What I now need is a nested call to read another file (or 2 but I have no issues running another script for the second file. If both can be included all the better) and use the 2 variables as Search/Replace values.

I spend most of yesterday searching and in quite a few instances I see hardcoded values of the S/R terms but was unsuccessful with this scenario of passing variables in.
I also do now know what else to add to my search terms to be more specific as they describe what I need to do.

Thanks in advance for any and all help
Greg

Batch is generally a poor language choice for manipulating text files. Simple solutions have many limitations that frequently make them useless for the task at hand. Robust solutions require a lot of arcane code.

I have a simple solution for you that uses JREPL.BAT - a regular expression text processing utility. JREPL is pure script (hybrid batch/JScript) that runs natively on any Windows machine from XP onward - no 3rd party exe file required.

My JREPL solution uses three steps, described in comments within the code:


Dave Benham

Thanks Dave, I'll take a look.
I also might have not been clear in that my 2 updateable files are different from the FROMTO file.
That file only includes the search/replace entries that will be searched for in the other 2 files that are much larger.

Thanks
Greg

Also prohibited from downloading zip file here at the workplace.