Spreadsheet function format problems

[dstoyanov5]

Hi everyone!
I'm having an issue with the "Spreadsheet String to Array" function in LabVIEW. The input is a text file containing IMU data, but the output values are not in the floating-point format I expected.
Could someone help me figure out what I'm doing wrong? Thanks in advance!

[GerdW · Accepted solution]

H dstoyanov,

---

@dstoyanov5 wrote:

but the output values are not in the floating-point format I expected.

---

Because your computer is set to use a comma as decimal separator, but the file is using a point instead!

Read the help for those format codes to adjust the format string as needed…

[Yamaeda · Accepted solution]

Set the Format Specifier to %.;%f to force it to use decimal point.