HI all,
I have a scripting question for all you experts:
Using CMD Line I output the file/folder path to the same filename (text file) in 10000 locations, the files contain different content. I want to now run a script to open up each file, search for a specific text string (ABC123, or ABC456, or ABC789). Once I find the text, I want to copy the file folder location where that text exists into 1 of three spreadsheets (depending on the result of the search), ABC123.xls, or ABC456.xls, or ABC789.xls), new lines on the spreadsheet for every result.
I am not good at scripting, and it took me a full day to come up with the cmd line to get the output file [dir /b/s index.xml > listing.xls] any help would be greatly appreciated.
Thanks,
PESZO
I have a scripting question for all you experts:
Using CMD Line I output the file/folder path to the same filename (text file) in 10000 locations, the files contain different content. I want to now run a script to open up each file, search for a specific text string (ABC123, or ABC456, or ABC789). Once I find the text, I want to copy the file folder location where that text exists into 1 of three spreadsheets (depending on the result of the search), ABC123.xls, or ABC456.xls, or ABC789.xls), new lines on the spreadsheet for every result.
I am not good at scripting, and it took me a full day to come up with the cmd line to get the output file [dir /b/s index.xml > listing.xls] any help would be greatly appreciated.
Thanks,
PESZO
