I am attempting to make a script to search through a text file and add the results to an excel spreadsheet. The speadsheet itself is very simple, headers for 'Technician','Customer Name', 'Start Date', 'End Date', etc. I would like to have these values read directly from the log files. The problem is that there are approx. 100 log files. I have no idea how to loop thru the files and add the data to the spreadsheet. The log files are set up like this:

Technician: Donald
Customer: John Doe
Start Date: 9/27/2011
End Date: 9/28/2011

The information does not exist on the same line number or anything, it is different for each log file. There is other information I would like to pull from the log files. I've done SOME scripting in the past, but nothing this complex, ANY help would be GREATLY appreciated. Thank You!!!
0 Comments   [ + ] Show comments


Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.


Start here. There are sample scripts there that you can adapt to suit your purposes, e.g. recursing through folders/files, parsing text in files, albeit separately. You should be able to find a script that will "talk" to Excel, too.
Answered 09/28/2011 by: VBScab
Red Belt