清空筛选条件
清空筛选条件

How to delete the row that contains specific string on the cells

4 次查看（过去 30 天）
Samantha Chong
Samantha Chong 2016-1-12
评论： Abhay khemka 2019-2-12
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.

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2016-1-12
row_to_delete = all( cellfun(@(C) ischar(C) && strcmp(C,'N/A'), YourCell), 2);
YourCell(row_to_delete, :) = [];

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by