Read Delimited Spreadsheet VI Does Not Output Decimals

Updated Jul 21, 2018

Reported In

Software

  • LabVIEW

Issue Details

I'm reading numeric data from a text file using Read Delimited Spreadsheet .vi and parsing it into Double data type. The results I'm obtaining are only the integer part of the data, the decimals are not converted. How can I solve it?

Solution

This is happening because the decimal separator format in the text differs from the one configured in Windows. There are two ways you can solve this issue:
  1.  Change the decimal separator format in Windows. This option is available in Control Panel >> Region >> Formats Tab >> Additional Settings >> Decimal Symbol2.
  2. Specify the decimal separator to use in the format input of the VI.  If, for example, the decimal separator is set as dot (".") in Windows, and the text file is using comma (",") as decimal separator, you should use the following string to read the decimals (%,;%f)