Trying to remove range of negative numbers from a specific column of multiple rows

Question

jgillis16 2015-7-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/228173-trying-to-remove-range-of-negative-numbers-from-a-specific-column-of-multiple-rows

评论： jgillis16 2015-7-3

within21rm.txt

I am trying to remove negative numbers < -13.5 from a text file from column 14 of each row (text file attached; within21rm.txt). I am using Idx=cellfun, but it isn't recognizing that I need to set a restriction on negative numbers.

Below is my code:

clear all
fidi = fopen('within21rm.txt','rt');
Glxc  = textscan(fidi, '%s', 'Delimiter','|');
frewind(fidi)
Glxcs = textscan(fidi, '%s', 'EndOfLine','\r\n');
fclose(fidi);
dlen = 18*fix(length(Glxc{:})/18);                          % Set Row Length
Glxcr = reshape(Glxc{:}(1:dlen), 18, [])';                  % Reshape & Transpose
Idx = cellfun(@(x) str2num(x) < -13.5, Glxcr(:,14), 'Uni',0); % Find Rows With Col14 < -13.5
LIdx = logical(cell2mat(Idx));                              % Logical Array From Cell
NewGlxc = Glxcs{:}(LIdx,:);                                 % Rows Of New Array
fido = fopen('faintgrm.txt','wt')
fprintf(fido, '%s\n', NewGlxc{:});
fclose(fido)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Azzi Abdelmalek 2015-7-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/228173-trying-to-remove-range-of-negative-numbers-from-a-specific-column-of-multiple-rows#answer_184959

在 MATLAB Online 中打开

dlen = 18*fix(length(Glxc{:})/18);                          % Set Row Length
Glxcr = reshape(Glxc{:}(1:dlen), 18, [])';                  % Reshape & Transpose
LIdx=str2double(Glxcr(:,14))<-13.5
NewGlxc = Glxcs{:}(LIdx,:);                                 % Rows Of New Array
fido = fopen('faintgrm.txt','wt')
fprintf(fido, '%s\n', NewGlxc{:});
fclose(fido)