problem in using textscan to import data from csv

5 次查看（过去 30 天）
kdilhara
kdilhara 2015-12-11
回答： dpb 2015-12-11
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
Walter Roberson 2015-12-11
Could you give a couple of sample lines? And also please show your current textscan attempt.

请先登录，再进行评论。

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

回答（1 个）

dpb
dpb 2015-12-11
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.

类别

在 Help Center 和 File Exchange 中查找有关 String Parsing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by