Delete values from different columns depending on a value from a specific column

I have a double variable with 3 columns. Sometimes, in the second column I obtain the value zero. In case it happens I want to completely erase that line. For instance:

12346 67 89

1245 0 765

56 0 99

19862 8 675

What I would like to get:

12346 67 89

19862 8 675

Thanks in advance for your help.

Answer 1

[Star Strider]

This works:

a = [12346 67 89;    1245 0 765;    56 0 99;    19862 8 675];

a((a(:,2) == 0),:) = [];

It uses ‘logical indexing’ to eliminate the entire row with a zero in the second column.

[Maria]

Thank you very much. It worked perfectly. :)

[Star Strider]

My pleasure!

The sincerest form of appreciation here on MATLAB Answers is to Accept the answer that solves your problem. It also helps others find it if they have similar questions.

[Maria]

Done!

[Star Strider]

Thanks!

[Maria]

Do you know how can I do the same, but considering the fact that some elements of the cell array are words (strings)? Thank you!

[Star Strider]

Here you go:

MCA = {1 2 3;   4 'ab' 6;   7 8 'bc';   4 3 8;  7 2 1;  'yz' 10 pi};    % Mixed Cell Array

FS = cellfun(@ischar,MCA);              % Find string elements

SR = find(sum(FS,2));                   % Find rows containing string elements

NSR = setdiff(1:size(MCA,1), SR)';      % Find rows NOT containing string elements

MCAnew = MCA(NSR,:)                     % Create new array

Have fun!