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)
 
​

Related Links

Localization Codes in LabVIEW

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement may be required, and support options vary by country.