Is there a function available to import row vectors from csv file?

I have csv files where the data is row wise. so the vector names are in first column and data is along the row. Is there are function available to import the data in matlab. The row vector sometime can be characters or numeric data. Any help would be appreciated. Thanks

Now I have attached sample data file also

Answer 1

[Image Analyst]

You forgot to attach the file. Failing that, all I can suggest is to try importdata() (which is pretty flexible in what it can understand), or textscan().

Answer 2

[Rajesh Patel]

Sorry, I have attached a sample file (I had to modify to remove confidential information). Vector names are in Column #2.

Thanks

Answer 3

[Image Analyst]

sampleData = importdata('sample.csv')

seems to work just fine. Any problem with it? If so, state what they are.

[Rajesh Patel]

I am sorry, I should have made the sample file exactly as real data file. The real data file has header information. I removed it in order to preserve the confidential information. I have created a new sample file (attached) which is nearly same as structure as the real data file. It seems that importdata is not able to import the data completely. Finally I need vectors with names in "B1:B29". I appreciate your help. Thanks

[Image Analyst]

importdata has a 'headerlinesIn' option where you can tell it to skip 20 lines, if there is a known number of header lines in the image. However there is a problem that you have lines like

-1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

that follow the data, and that causes it to throw an error. You might have to write a custom function that either (1) reads your code with fgetl() and textscan() to parse and convert lines of text as you go down line-by-line, or (2) read the file line-by-ling and write only the "good" data lines to a file called 'delete_me.csv' which you can then read with importdata() and delete after it's read in and you don't need it anymore.