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

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 Comments

You may want to show us your format string. And possibly attach one of the files where it is failing.
"(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
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.

Sign in to comment.

Answers (0)

Categories

Asked:

on 10 Oct 2014

Edited:

on 4 Dec 2014

Community Treasure Hunt

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

Start Hunting!