.CSV files to graph

[vin883]

Hi,

I'm trying to displays waveforms saved in .csv files from a Lecroy oscilloscope. An example of these files is attached. I can't manage to display the waveforms (10k points), it seems Labview does not recognize the engineering format with point decimal separator. I'm not US and use Labview 7.0.

Also attached the .vi I've built (and that does't work).

Any ideas?

[Cory_K]

1) The 'file' was an indicator, not a control, so LabVIEW didnt know where to look for the file.

2) Why doesnt your while loop have a 'wait' function? It will use up all your CPU

3) PLEASE tell me the 'string subset' function isnt to strip off the name of the file from the path.

Just use 'strip path'.

I attached a revised copy of your VI.

[Dennis_Knutson]

I don't think the real problem has anything to do with displaying the selected file in a string.

If the regional settings of your pcLabVIEW installation are to use the comma to separate the whole number from the decimal, then you need to override this in the format string. I believe this is a %.;

[smercurio_fc]

The user has LabVIEW 7, so a VI in 8.6 will do them little good.

The Read From Spreadsheet File will display a dialog if no path is specified, so there's no issue with having an indicator displaying the name of the file. But, you are correct that Strip Path should be used.

As to the issue with reading the files, you have to use the correct format specifier. If you want to force to use commas as the decimal point separator, then your format string should be %,;%f. If you want to specify a decimal point then use %.;%f. 

You have a secondary issue in that the data doesn't start until the 31st line. Thus, you need to chop off the header rows. Instead of using Index Array use Array Subset. 

[Cory_K]

---

smercurio_fc wrote:

The user has LabVIEW 7, so a VI in 8.6 will do them little good.

---

Doh!

[vin883]

Thanks for the strip path trick, but that wasn't the point.

I tried the %.;%f. format specifier but the numeric values still does not appear on the graph. Attached my modified vi.

[Dennis_Knutson · Accepted solution]

Don't use the . after the %f

That was a period to end the sentence and not part of the format string.

[vin883]

Thanks Dennis!

But it still doesn't display the waveform

[Dennis_Knutson]

This is what I see. However, my regional settings do not use the , so I read the file from the very beginning