Searching Text file and Adding Results to Excel Speadsheet
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!!!
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
Answers (1)
Please log in to answer
Posted by:
anonymous_9363
12 years ago
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
