Read data from CSV files

Hi,

I would like to read data from a CSV file between column A and column K such that those columns contains numbers only. In that file, column L is not number but alphabets. When I use the function "csvread" it gives the following error message:

Mismatch between file and format string. Trouble reading number from file (row 1, field 12) ==> F, 0

I am wondering how can I read the data from that CSV file?

By the way, I am using Matlab R2006a.

Thanks,

Alan

[Chirag Gupta]

http://www.mathworks.com/matlabcentral/answers/4840-read-csv

[Alan Leung]

I specify the column range (column A to column K), but it still gives the error.

I have 150+ CSV files, so I have to change those files one by one, even though I have Matlab!?

Answer 1

[Chirag Gupta]

Try using textscan to read your data.

http://www.mathworks.com/help/techdoc/ref/textscan.html

Typical usage:

fid = fopen(filename,'w');

data = textscan(fid,'%g %g %g %g %g %g %g %g %g %g %g %*s','delimiter',',');

fclose(fid);

[Alan Leung]

The data that I want to read start from row 3 as the format of row 1 and row 2 is different. Please advice how I can skip row 1 and 2.