IOmeter: What are you using to parse CSV?

[Patrick]

Just tried IOmeter's old Wizard.mdb on Access 2013 in the hopes that I could make some cool Excel 2013 graphs but with no luck. Wondering what folks are using to parse IOMeter output these days.

 

[cactus]

I've never looked at the IOmeter CSV output, but why not just open it with Excel directly?

 

[Patrick]

Opening it isn't an issue. It is getting the information into something quickly usable and comparable that I'm looking for.

 

[Salami]

If you can't make the graphs within Excel, a free option would be MS SQL Server Reporting Services Express Edition. But that may be too much trouble for what you need, unless you are already familiar with SQL Server and report creation

 

[Patrick]

The issue is really the format of the data. Graphing is easy, I just want to see if there is an Access or Excel macro that will parse the CSV for me.

 

[john4200]

What exactly do you mean by "parse"? Are you looking for some sort of graphing wizard specifically for CSV output from IOMeter?

 

[Patrick]

If you directly import IOMeter CSV's in Excel 2013 you have to do a lot of manual data massaging to get something useful for graphing. Was thinking that if there was a way to easily take raw CSV output and put it into a ready-to use Excel format that would be great.