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
etc.

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

Comments

Please log in to comment

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

Answers

-2
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

Please log in to comment
Answer this question or Comment on this question for clarity