Problem by importing alpha numeric text files
조회 수: 1 (최근 30일)
이전 댓글 표시
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
채택된 답변
Oleg Komarov
2011년 8월 28일
fid = fopen('c:\myfile.txt');
data = textscan(fid,'format','TreatAsEmpty','NA','EmptyValue',NaN);
fclose(fid);
댓글 수: 3
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,...)
추가 답변 (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!