How to delete the row that contains specific string on the cells
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Samantha Chong
am 12 Jan. 2016
Kommentiert: Abhay khemka
am 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 Kommentare
Akzeptierte Antwort
Walter Roberson
am 12 Jan. 2016
row_to_delete = all( cellfun(@(C) ischar(C) && strcmp(C,'N/A'), YourCell), 2);
YourCell(row_to_delete, :) = [];
2 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Characters and Strings finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!