Clear Filters
Clear Filters

How to delete rows from a CELL with certain values?

3 views (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)

Categories

Find more on Multidimensional Arrays in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!