We have just finished our pilot of 400 workstations migrating to XP SP2. USMT was the tool used for data migration. We have several progress log files that we want to extract information from, then put that info into a spreadsheet with defined column headers. Here's what i thinking of:
1- browse to or define the folder where the text files reside
2-write the filename of each file in that folder to a spreadsheet (column A)
3-read each file for a line that contains specific data/value
4-write the contents of that entire line into the spreadsheet's row that contains the corresponding filename from (column A).
Ex: If the file contains "end,scanstate"; then write that entire line into the spreadsheet with the data/values (separated by a comma) in the appropriate columns. Same applies for the same file: if contains "end,loadstate."
Essentially, that's the information i want out of the several lines one (1) file will contain. It is possible that a file could contain more than one instance of the "End, Scanstate" or End Loadstate."
As mentioned i have approx 472 files from our pilot. Upon completion there will be several thousand log files that i would need to extrrapolate this info.