Find rows where one column value matches with any value inside another array

Question

Anil Verma 2016-8-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/298726-find-rows-where-one-column-value-matches-with-any-value-inside-another-array

回答： Star Strider 2016-8-7

采纳的回答： Star Strider

在 MATLAB Online 中打开

I am new to Matlab, so please respond even if the question is trivial

I have a matrix. Lets say matrix is

A =[
   2     3    13
  11    10     8
   7     6    12
  14    15     1]

I have an array. Lets say array is

B = [3, 6, 15]

I want to find out all the rows of Matrix A where column 3 value of Matrix A matches with any value mentioned in the array B. In the above case output will be

ans = [
   2     3    13
   7     6    12
  14    15     1]

I don't want to use loop for this calculation. Is there any built in function which does this.

Thanks

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2016-8-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/298726-find-rows-where-one-column-value-matches-with-any-value-inside-another-array#answer_231032

在 MATLAB Online 中打开

This works:

A =[16     2     3    13
     5    11    10     8
     9     7     6    12
     4    14    15     1];
B = [3, 6, 15];
idx = ismember(A(:,3),B);
Result = A(idx,:)
Result =
      16     2     3    13
       9     7     6    12
       4    14    15     1