Loading data from csv causes issues

[Silverfang-]

Hey everyone,

So I am using Labview for data reduction and one of the things I need to do is read a data file and process it a certain way.

The basic problem I am having is my data file is in .csv so when i load the file, the data that I am seeing comes with these "" marks and a space.

I don't understand why and sometimes because of this, some of processing loops don't execute properly. Image attached.

When i convert the csv to a txt file and then use the read delimited spreadsheet function everything works perfectly. But I have to convert csv to txt everytime which is a pain.

Does anyone have any suggestions? Thanks in advance!

[Eric1977]

Do you happen to have the CSV file handy?

[Silverfang-]

Attached

[jcarmody]

I read the above CSV file and got what I expected.

[RTSLVU]

---

@Silverfang- wrote:

Hey everyone,

So I am using Labview for data reduction and one of the things I need to do is read a data file and process it a certain way.

The basic problem I am having is my data file is in .csv so when i load the file, the data that I am seeing comes with these "" marks and a space.

I don't understand why and sometimes because of this, some of processing loops don't execute properly. Image attached.

When i convert the csv to a txt file and then use the read delimited spreadsheet function everything works perfectly. But I have to convert csv to txt everytime which is a pain.

Does anyone have any suggestions? Thanks in advance!

Not all CSV files are created equally, for instance Excel can save a file to FIVE different types of CSV files.