12-04-2014 07:56 AM
How can I take the csv file generated by the export command from virtualbench directly into matlab to analyze oscilloscope data? What is the meaning of the different fields in the exported CSV file? Foreach channel there are high and low values. What does that mean as well. Do we average them?
Thanks
Harry
12-04-2014 08:42 AM
The high and low values are from acquiring in Peak Detect mode.
WilliamEarle explains further in this post: Question on Exporting Data from Virtualbench
12-04-2014 08:52 AM
Yes, i got that one figured out. Is there a simple way to just get the data into matlab, without all of the setup fields that seem to be in the csv as well? Are all of the other fields always in the same place in the csv, so we can just omit them?
Thanks
Harry
12-04-2014 12:33 PM
The .csv data exports are optimized for viewing in Excel, not optimized for programmatic scripting. It can be done, but it's does require nontrivial parsing.
Fields aren't guaranteed to have a particular absolute position, but they are at predictable relative locations. (For instance, if you have a large number of digital channels configured, that will increase the number of rows that the configuration section occupies, but the data section follows right after. The instruments are also in the same order left-to-right.)
If trying to parse out the MSO analog data programmatically, I'd go for a strategy like:
The Read From Spreadsheet File LabVIEW VI might be useful here to read the whole .csv into a 2D array. I've not used Matlab, so I don't know how you'd accomplish that processing there.