I want to read and parse a .CSV file.

[vehnasa]

I have what I hope it is not a unique problem. I want to read and parse a .CSV file. The file is large and the first two rows are data type string

and the third column is also of data type string all the rest of the columns and rows are of data type double. I want to do is make the first to

rows of the .CSV file the header of an .XLS file and the the third column in the .CSV file the first column in the .XLS file. The remaining data

is to be used for calculations.  I have used the 'Read From Spreadsheet' function to read the file but the string data are rendered zero when 

double type read is selected and vice versa for string type read with the doubles. Can anyone provide some insight on how to make this happen??

I am under the gun to perform data analysis for a study I am conducting and the previous analysis code leaves a bit to be desired.

Any help will be greatly appreciated.

Thanks everyone,

  Vincent

[Pnt]

---

Vincent wrote:

I have used the 'Read From Spreadsheet' function to read the file but the string data are rendered zero when 

double type read is selected and vice versa for string type read with the doubles.

---

If string is selected, use "Decimal string to number" to convert the strings to numbers.

You should post a small file, with a simple vi, if you have further problems.

What you are trying to do is quite trivial

[clark.leach]

You may find it more straight forward to read the CSV file as text (Read from Text File) and then manipulate the data as you see fit.  You can convert each line to an array of strings using 'Scan String for Tokens' or the OpenG VI 'String to 1D Array' or similar techniques.  This should get the data (as strings) into a 2D array which you can convert and manipulate at will.

Hope this helps.

[alinecfadel]

Anyone has a example for this?

Tks!

[Dennis_Knutson]

---

alinecfadel wrote:

Anyone has a example for this?

Tks!

---

duplicate post