Problem by importing alpha numeric text files

1 次查看（过去 30 天）
Emerson De Souza
Emerson De Souza 2011-8-28
Hi,
INTRO:
I have an alpha numeric text file. Thus, among many values, I have
also the output 'NA' for non available value of a given row and
column number.
PROBLEM:
I don't know how to load this type of table. It seems that Matlab
matrices can't include alphanumeric quantities.
I used the command line:
X=load('X.txt');
and it always returns the
error:
??? Error using ==> load Unknown text on line number 1 of ASCII file
QUESTION:
I wounder if someone knows what I have to change to load the matrix
as original and still be able to perform calculations with it.
I don't want to substitute 'NA' by zero because I don't want that
the value zero be included in further statistical calculations, such
as median, etc...
Thank you,
Emerson

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

采纳的回答

Oleg Komarov
Oleg Komarov 2011-8-28
Use textscan:
fid = fopen('c:\myfile.txt');
data = textscan(fid,'format','TreatAsEmpty','NA','EmptyValue',NaN);
fclose(fid);
  3 个评论
显示 1更早的评论
Oleg Komarov
Oleg Komarov 2011-8-28
You have to insert a valid format as explained in the documentation (see link).
In your case
fmt = '%f%f%f%f%f%f';
textscan(fid,fmt,...)
Emerson De Souza
Emerson De Souza 2011-8-28
Thank you a lot Oleg!
Problem is fixed by your suggestions.
Wish you a nice day
Emerson

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by