Hello, I try to read a csv file with LabVIEW. This is my VI for reading the csv file: This is the ";" delimited csv-file, which I want to read: This is what I get: As you can see, there is a "0" in the first column and first row. Does anybody know what causes this behaviour? Thank you very much in advance. Best regards, Michael

Your file contains a three-byte Byte Order Mark (BOM) declaring that the file is encoded in UTF-8. In this case, it's a useless information since all characters are ASCII. LabVIEW does not support BOMs anyway. You may set your editor options to avoid writing the BOM. As an alternative, open your file with Notepad, then choose Save As... setting ASCII as encoding options. See below (doing a little translation to your language):

Hi Michael, as Jens told you: there are some additional bytes at the beginning of your file! You probably edited that file using a text editor (like Notepad) instead of creating it directly from Excel… See this view of your textfile using a hex viewer: The first 3 bytes are used to determine the UTF status of that text file. LabVIEW doesn't handle those bytes explicitely and when reading a delimited text file it tries to convert that file content like any other file content…

LabVIEW

Problem with the "Read Delimited Spreadsheet VI"

Solved!

Author

Hello Paolo,

thank you very much for your reply. Saving the file with ANSI works for me.

Best regards,

Michael

Message 11 of 11

(367 Views)

LabVIEW

Problem with the "Read Delimited Spreadsheet VI"

Re: Problem with the "Read Delimited Spreadsheet VI"