Problem by importing alpha numeric text files

2 visualizaciones (últimos 30 días)
Emerson De Souza
Emerson De Souza el 28 de Ag. de 2011
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

Respuesta aceptada

Oleg Komarov
Oleg Komarov el 28 de Ag. de 2011
fid = fopen('c:\myfile.txt');
data = textscan(fid,'format','TreatAsEmpty','NA','EmptyValue',NaN);
fclose(fid);
  3 comentarios
Oleg Komarov
Oleg Komarov el 28 de Ag. de 2011
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 el 28 de Ag. de 2011
Thank you a lot Oleg!
Problem is fixed by your suggestions.
Wish you a nice day
Emerson

Iniciar sesión para comentar.

Más respuestas (0)

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by