Find elements in a matrix

I have a very large matrix A with 4 columns and hundreds of thousands of rows - the first 3 columns contain x, y and z coordinates and the fourth column contains elevation values. I have another smaller matrix B of 3 columns containing x, y and z coordinates at which I need to extract the elevation values from the larger matrix. How do I search for the particular coordinates (given by B) in the larger matrix A? I tried to use 'find' to extract the indices of every match: >> ind=find(B==A(:,1:3))
but I get the error "Matrix dimensions must agree".

 Accepted Answer

the cyclist
the cyclist on 31 May 2014
Edited: the cyclist on 31 May 2014
[tf idx] = ismember(B,A(:,1:3),'rows')

3 Comments

Rinu
Rinu on 31 May 2014
Edited: Rinu on 31 May 2014
I think that command only tells whether the rows of B occur in A or not. In this case, all the rows of B occur in A, but I want to find the exact location where it occurs so that I can extract the fourth column value (elevation) of the larger matrix and paste it to a fourth column in the smaller matrix. Thanks anyways.
the cyclist
the cyclist on 31 May 2014
Edited: the cyclist on 31 May 2014
The second output of the ismember command gives the index to the corresponding row.
Oh Thanks :-)

Sign in to comment.

More Answers (0)

Tags

Asked:

on 31 May 2014

Commented:

on 31 May 2014

Community Treasure Hunt

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

Start Hunting!