Read data from CSV files

1 次查看（过去 30 天）
Alan Leung
Alan Leung 2011-4-29
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
Chirag Gupta 2011-4-29
http://www.mathworks.com/matlabcentral/answers/4840-read-csv
Alan Leung
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!?

请先登录，再进行评论。

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

回答（1 个）

Chirag Gupta
Chirag Gupta 2011-4-29
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 个评论
Alan Leung
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by