TEXTSCAN problem using TREATASEMPTY

3 次查看（过去 30 天）
Jeremy Smith
Jeremy Smith 2011-7-21
评论： Jeremy Hughes 2017-11-20
D = textscan(fid,'%q%f%f%f%f%f%f%f%f%f%f%f%f%f%f','Delimiter',',','HeaderLines',4,'TreatAsEmpty',{'"NAN"','"INF"','"-INF"','"1.#INF"','"-1.#IND"','"#NAME?"'});
This fails.
D = textscan(fid,'%q%f%f%f%f%f%f%f%f%f%f%f%f%f%f','Delimiter',',','HeaderLines',4,'TreatAsEmpty',{'"NAN"'});
This works.
The file in question looks much like the following line.
"2011-04-19 11:55:30",521882,1,25.5,347.068,3.765646,1.54899,18.43283,204.205,125.9697,10,651.2458,9.310149,"NAN","NAN"
The last two columns are all "NAN" values. When using the first code example Matlab loads all data except for the very last value. If the very last value is replaced by a number it loads everything.
What is going on with TEXTSCAN?
  1 个评论
Jeremy Hughes
Jeremy Hughes 2017-11-20
Try adding
'ReturnOnError',false
to get a better diagnostic of why textscan stops there.

请先登录，再进行评论。

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Export 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by