Problem with "Read Delimited Spreadsheet"

[Naeryan]

Hey everybody,

I am very new to Labview and currently trying to read a CSV file containing 3000 Datapoints measured by an oscilloscope into Labview for some analysis. The format is as follows:

For this, I am using the "Read Delimited Spreadsheet" vi, with two probes to debug my problem:

The Probe 9 shows, that the string is read correctly: 

however no matter which format specifier I use for the "Spreadsheet Strong to Array Function", the output at Probe 8 always ends up like this (converted to integer for some reason?):

Since the examples for the Format Specifier Syntax did not feature Input in scientific notation, I am assuming this might be the problem. Is there any way for me to get an ouput in scientific notation using this vi, or do I need to do something more complicated?

Any help is appreciated

Naeryan

[GerdW · Accepted solution]

Hi Naeryan,

which decimal separator is used in your regional computer settings?

Try the format code "%.;%f" to force the point as decimal separator!

Don't forget to use the comma as separator in SpreadsheetStringToArray…

[Naeryan]

wow, that did actually fix the problem. I just changed the "use localized decimal point" option and now it even works without your format code. Seems like a somewhat counterintuitive thing to have as a default setting. 

Thank you for the quick help

Naeryan