How to delete rows from a CELL with certain values?

1 view (last 30 days)
It has thousands of rows and I want to remove any row with 0 or 99 or 999 in the row 12 and 13

Accepted Answer

Jos (10584)
Jos (10584) on 9 Jun 2016
Similar question, similar answer ...
You should be able to modify the code from that one!
If you do not understand it, just ask for some more explanation...
  2 Comments
Akhil  Reddy
Akhil Reddy on 9 Jun 2016
what if i need to check values from particular column?
Jos (10584)
Jos (10584) on 9 Jun 2016
Fair enough. You can select the columns first:
A_selected = A(:, [ 12 13]) ;
tf = ~any(cellfun(@(x) isequal(x,0) || isequal(x,99),A_selected, 'un',1),2) ;
B = A(tf,:) ;

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!