Does textscan not work properly/needs some other inputs in R2013b?

4 次查看（过去 30 天）
Aniket Vagha
Aniket Vagha 2014-10-10
编辑： Aniket Vagha 2014-12-4
I use textscan to read data from a large number of .csv files. The script works perfectly well on my work laptop (64-bit, R2010a), but fails to read any data when I use the same script on my workstation (64-bit, R2013b).
The red text I see on R2013b: Error using textscan Mismatch between file and format string. Trouble reading number from file (row 1u, field 9u).
Command I am using:
Data = textscan( fid, DataFormat, NumberOfRows, 'delimiter', ',' ...
, 'treatAsEmpty', {'NA', 'Unknown'}, 'headerlines', NumOfHeaderlines ...
, 'ReturnOnError', false)
Please advise.
  3 个评论
显示 1更早的评论
per isakson
per isakson 2014-10-10
"(row 1u, field 9u)" &nbsp Is that really a "u"? Encoding problem?
"Mismatch between file and format string" &nbsp What is the value of fid?
I'll test with R2013b if you attach a data-file
Aniket Vagha
Aniket Vagha 2014-12-4
编辑：Aniket Vagha 2014-12-4
Apologies! I had forgotten to attach the file.
I used this: fid = fopen('textscan_temp.xlsx'); data = textscan(fid, '%d %d %d %s').
I got empty cell array.

请先登录，再进行评论。

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

回答（0 个）

类别

在 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