I have this file "generated" from a script but I want to get the formatting better so that when the text is imported into Excel as CSV, each "counter" type gets a column.
If you look at the attached document, it has a bunch of data as per below...
0323-1135 DB Writes 2315
0323-1205 DB Writes 3078
0304-0705 BI Reads 25
0304-0735 BI Reads 9
0304-0705 BI Writes 1642
0304-0735 BI Writes 301
0304-0705 AI Writes 1148
0304-0735 AI Writes 232
Ideally, I want the script to format this better, and the output to be as below:
Date,DB Writes,Bi Writes,AI Writes
For each of the dates, there is a value for the multiple counters.
If I am able to archive this, it makes it much easier to import into excel, and have excel graph the data.
Any help would be appreciated.