Read data from CSV files

Question

0 个投票

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

2 个评论
显示无隐藏无

Chirag Gupta 2011-4-29

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

Alan Leung 2011-4-29

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!?

请先登录，再进行评论。

请先登录，再回答此问题。

Follow Question

Answer 1

Chirag Gupta 2011-4-29

在 MATLAB Online 中打开

0 个投票

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);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Alan Leung 2011-4-29

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.

请先登录，再进行评论。

Read data from CSV files

2 个评论
显示无隐藏无

回答（1 个）

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

类别

标签

Community Treasure Hunt

Read data from CSV files

2 个评论 显示 无 隐藏 无

回答（1 个）

1 个评论 显示 -1更早的评论 隐藏 -1更早的评论

类别

标签

另请参阅

Community Treasure Hunt

2 个评论
显示无隐藏无

1 个评论
显示 -1更早的评论隐藏 -1更早的评论