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.

[altenbach]

---

@Silverfang- wrote:

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.

---

As others have already said, there are no such characters in this attached file. You can easily see this in notepad.:

Can you explain what you mean by "convert csv to txt"? Both format are plain text files, there is nothing to convert!

Are you just renaming the extension or do something more evil, such as using some questionable program found on the web?