Problem by importing alpha numeric text files

2 次查看（过去 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 中查找有关 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