How to delete the row that contains specific string on the cells
1 view (last 30 days)
Show older comments
Samantha Chong
on 12 Jan 2016
Commented: Abhay khemka
on 12 Feb 2019
Hi, I have an array of 80x2, and I would like to delete the rows only if both cells in a row contain the string 'N/A'. Attached is an example of the first 24 rows. The idea is I hope the code can find out which rows contain 2 'N/A', and then delete that corresponding row.
0 Comments
Accepted Answer
Walter Roberson
on 12 Jan 2016
row_to_delete = all( cellfun(@(C) ischar(C) && strcmp(C,'N/A'), YourCell), 2);
YourCell(row_to_delete, :) = [];
2 Comments
More Answers (0)
See Also
Categories
Find more on Characters and Strings 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!