I have a database statistic report that gets created every time my script runs to sample the many "counters" that are important to a database administrator.
What I want to do is take this further and extract data from the report in a CSV like format so that I can plug it into Excel and graph the values to better understand the big picture with charts.
Attached is a sample of the "report", this gets produced a few times per day on a 30 minute interval, so I have a directory with a bunch of files with the current time-stamp as the file-name..
Each file is identical to the attached example, except the counters (values) are different.
Now I want to extract that from each file in the directory in a comma separated format as per example:
So if you are following, it would be [date][type of counter][value]
If someone could show me an example of how to do this, by scripting it or in excel or something.. or any other program out there that can do this.. that would be very helpful.
Thank you for your time.