Japanese Characters in CSV File Are Not Read Properly in LabVIEW

Updated Aug 2, 2020

Reported In

Software

  • LabVIEW
  • LabVIEW NXG

Issue Details

When I open csv file with Read Delimited Spreadsheet.vi, Japanese characters in the csv file were not read property (garbled). How can I read them correctly ?

Solution

When you use Read Delimited Spreadsheet.vi you have to choose string data type from polymorphic selector. If you already select it and still see the wrong Japanese characters, you have to check if the csv file is not saved in UTF-8 format. You have to choose other character code such as Shift_JIS.

Additional Information

In other situaion, you may want to use Unicode format. But LabVIEW originally does not have support for Unicode character. If you want to use Unicode character in LabVIEW program, see the documents in related links or consider to use LabVIEW NXG which has Unicode support.