How to remove all the rows containing a substring from a table?

Question

Chiara Scarpellini 2021-8-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/895817-how-to-remove-all-the-rows-containing-a-substring-from-a-table

编辑： Stephen23 2021-8-11

采纳的回答： Wan Ji

I need to remove all the rows containing the substring Downstream from the table.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Wan Ji 2021-8-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/895817-how-to-remove-all-the-rows-containing-a-substring-from-a-table#answer_764552

在 MATLAB Online 中打开

Assume the table is named 'myTable'.

Then

p = arrayfun(@(i)strncmpi(myTable.beregnings{i}(end:-1:1),'maertsnwod',10),(1:1:size(myTable,1))','uniform',true);
newTable = myTable(~p,:);

Your newTable is therefore what you want!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Stephen23 2021-8-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/895817-how-to-remove-all-the-rows-containing-a-substring-from-a-table#answer_764717

编辑：Stephen23 2021-8-11

在 MATLAB Online 中打开

Simple and efficient MATLAB approach:

A = [0;1;2;3;4];
B = ["cat";"hat";"sat_Downstream";"fat";"rat_Downstream"];
C = [5;6;7;8;9];
T = table(A,B,C)
T = 5×3 table
    A           B            C
    _    ________________    _

    0    "cat"               5
    1    "hat"               6
    2    "sat_Downstream"    7
    3    "fat"               8
    4    "rat_Downstream"    9
X = contains(T.B,'Downstream'); % or endsWith
T(X,:) = []
T = 3×3 table
    A      B      C
    _    _____    _

    0    "cat"    5
    1    "hat"    6
    3    "fat"    8