Find equal rows between cell array and matrix into for loop

Hi everybody,

i have a matrix (A) and a cell array (B) as follow:

A

-0.11 7.17 3.66

-0.09 3.45 1.55

-0.21 2.17 9.87

-0.14 4.88 6.66

B{1,1} B{1,2}

-0.09 3.45 1.55 -0.14 4.88 6.66

I need to detect the number of row of A equal to B{1,1} and B{1,2}. In this exemple i need to create a matrix or a cell array C as follow:

C

2

4

Thank you very much!

Riccardo

Answer 1

[Bruno Luong]

Try this:

A=[-0.11  7.17  3.66
-0.09  3.45  1.55
-0.21  2.17  9.87
-0.14  4.88  6.66]

B{1,1} = [-0.09  3.45  1.55]
B{1,2} = [-0.14  4.88  6.66]

C = find(ismember(A,cat(1,B{:}),'row'))

[Riccardo Rossi]

Thank you for your answer. It runs!

Do you know if it is possible to obtain the following result?:

C

2 1

4 2

with the second column that represent the correspondent cell of B (respectively B{1,1} B{1,2}).

Thanks

[Bruno Luong]

bnum = repelem((1:numel(B))',cellfun('size',B(:),1))
[tf,bloc] = ismember(A,cat(1,B{:}),'row');
C = [find(tf),bnum(bloc(tf))]

Answer 2

[Alex Mcaulley]

A = [
-0.11  7.17  3.66
-0.09  3.45  1.55
-0.21  2.17  9.87
-0.14  4.88  6.66];
B = {[-0.09  3.45  1.55],[-0.14  4.88  6.66]};

[~,C] = ismember(cell2mat(B'),A,'rows')