problem in using textscan to import data from csv
显示 更早的评论
I need to import a csv file with 60 columns. All have numerical values. However, some values are missing and instead of keeping it as 0 or Nan, those columns have "*****" and when importing using textscan it gives an error.
So how can I replace those string parts (******) with NaN and import it as numbers.
so finally my requirement is to import the csv file to number arrays with replacing "*****"with NaN
1 个评论
Walter Roberson
2015-12-11
Could you give a couple of sample lines? And also please show your current textscan attempt.
回答（1 个）
dpb
2015-12-11
0 个投票
Filling a field with asterisks is Fortran convention if output magnitude exceeds available width for a field; possibly can you rework the application building the output file to correct such?
Failing that, use the 'TreatAsEmpty','******' option to cause textscan to return those fields as missing values.
类别
在 帮助中心 和 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 
