How to delete rows from a CELL with certain values?
1 view (last 30 days)
Show older comments
It has thousands of rows and I want to remove any row with 0 or 99 or 999 in the row 12 and 13
0 Comments
Accepted Answer
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
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,:) ;
More Answers (0)
See Also
Categories
Find more on Matrix Indexing 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!