I am attempting to write serial decoder application that would process data in a CSV file. My Rigol scope will export such a file. Do other DSOs have this feature?
Attachments
-
8.6 KB Views: 7
I just got a Siglent SDS1202X-E, delivered today; the manual says it exports .CSV files.I am attempting to write serial decoder application that would process data in a CSV file. My Rigol scope will export such a file. Do other DSOs have this feature?
I'll do it tomorrow. Gotta read the user's manual first to figure out how.Can you post an example of an export of your calibration port when you get a chance? I want to see if it is similar to mine. No rush.
So far, after playing around with it for an hour or so, I'm pleased.I am considering a SDS1202X-E myself.
OK, I figured it out. I'm not going to post the entire file (67 MB), here's just the header info and the first few readings. The filename is test.csv.


Yup, other than the fact that I deleted all but the first few data records to reduce the file size.Was this the file as it was output from your scope?
MS Excel on my MacBook renders it correctly:If so, it looks like their CSV file creator is a little buggy. Notice that that CH1 Volt appears over the time column.


Those aren't duplicate entries for each time point; it only looks that way because of how your spreadsheet is formatting the numbers for display. Try specifying a format with more significant digits.Mine is different. I don't have any of that header information at the top. I have negative values for time that is left of the center vertical gradient. It also looks like they are including one time entry for each channel which is really dumb imho.
Sounds like a bug in Open Office then. What if you wanted a leading space? It should have handled it like a string.Yup, other than the fact that I deleted all but the first few data records to reduce the file size.
MS Excel on my MacBook renders it correctly:
View attachment 138636
This is the actual contents of the file, as viewed in a plain ASCII text editor (BBEdit):
View attachment 138637
I noticed there is a leading space before each data record; maybe that is what's causing your spreadsheet program (OpenOffice?) to insert an extra column?
Yeah pointed out in another thread. I should have looked at the raw data. I feel dumb. But Calc really should have some kind of warning that not all data is displayed.Those aren't duplicate entries for each time point; it only looks that way because of how your spreadsheet is formatting the numbers for display. Try specifying a format with more significant digits.
Excel doesn't have any such warning, either, because it's really not necessary: people usually understand that numbers are displayed according to cell formatting preferences, and generally will NOT be an exact representation of the underlying data. You pick the display format that best suits your purpose, and that may not be the default format.But Calc really should have some kind of warning that not all data is displayed.