Read  Character in LabVIEW using Read Delimited Spreadsheet (string) VI

Issue Details

Upon reading header text file that have  character using Read Delimited Spreadsheet (string) VI, the  from [µm] is garbled to Â, from [‚µm] based on below screenshot.

Hence how can I read the  character in LabVIEW using Read Delimited Spreadsheet (string) VI?

Solution

In the first place,  from [µm] might be due to the original csv file or header text file is having encoding mismatch on the µ character, as character µ consists of two bytes of 0xC2 and 0xB5, where the 0xC2 byte will be garbled to  upon encoding mismatch hence you will get the extra symbol of  which is expected results.

Therefore, ensure that the original csv files not having encoding mismatch upon open it hence also not having encoding mismatch upon changing it to header text file so that it can correctly be read in LabVIEW.

If you intend to keep the  character from the encoding mismatched original csv files or header text file as the application will be used in various systems and PC, consider adding an extra program in LabVIEW to remove the extra symbols of Â.