what's wrong with this command isempty(strfind(l,'NA')) ??
i have used the code below to delete NA rows but when i execute it i found all NA's rows deleted even NA included in strings such as 'RNASE', 'GNAS'…..
fid = fopen('file1.txt','rt'); %open original file
fid2= fopen('file2.txt','wt'); % open new text file
l= fgetl(fid); %first line
l= fgetl(fid); % the second line
while ~feof(fid) l=fgetl(fid); %get the next lines
if isempty(strfind(l,'NA'))==0 %remove NA rows
else idx=regexp(l,'\t','split'); [nrow,ncol]=size(idx); %size of idx (total number of columns in every row)
......... endend
input:
- 0.121213 NA 0.589999
- 0.421566 RNASE 0.356955
- 0.11111 GNAS 0.0311120
- 0.158881 NA 0.0158999
- 0.122222 SLTP 0.016666
output:
- 0.122222 SLTP 0.016666
output wanted:
- 0.421566 RNASE 0.356955
- 0.11111 GNAS 0.0311120
- 0.122222 SLTP 0.016666
Best Answer