Check for repeated values in two cell arrays in matlab

4 views (last 30 days)
I have 2 cells with 5 columns and I want to verify whether there are no repetitions in the values of the 1st columns. For example:
a={ 701 452 8 407 31
1037 110 14 873 93
*7985* 881 20 16 69
9420 481 9 191 95}
b={4220 308 118 464 24
*7985* 112 58 37 19
9639 61 29 96 21
9999 34 16 89 37}
In the 3rd row of a & in the 2nd row of b the values of the first column are equal . In that case I would like to obtain a new variable that identifies the lines in which the values are the same.
ab={3 2}
Can someone help me? Thanks

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 4 Aug 2014
Edited: Azzi Abdelmalek on 4 Aug 2014
a={ 701 452 8 407 31
1037 110 14 873 93
7985 881 20 16 69
9420 481 9 191 95}
b={4220 308 118 464 24
7985 112 58 37 19
9639 61 29 96 21
9999 34 16 89 37}
a1=[a{:,1}]
b1=[b{:,1}]
[ii,ii]=find(ismember(a1,b1))
[jj,jj]=find(ismember(b1,a1))
out={ii' jj'}

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!