Problem by importing alpha numeric text files
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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
0 commentaires
Réponse acceptée
Oleg Komarov
le 28 Août 2011
fid = fopen('c:\myfile.txt');
data = textscan(fid,'format','TreatAsEmpty','NA','EmptyValue',NaN);
fclose(fid);
3 commentaires
Oleg Komarov
le 28 Août 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,...)
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Text Files dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!