extracting values and respective rows from a colummn

Hallo,

this is my problem:

I have a column B and a matrix A A contains in its first column the values of the B But A has a lot more values which I do not need. I want to create a code that extracts from the matrix A the rows corresponding to the values that are in the B column.

Hope that somebody can help,

Thanks in advance.

Sami

Answer 1

[Matt Fig]

I assume your A and B look something like this:

% Create some data to work with...
B = [3 5 7 9].';  
A = round(rand(10)*100)/100; 
A([2 10 4 7],1) = B  % Put B in first column of A

To get the rows of A which have the values of B in the first column:

A_new = A(ismember(A(:,1),B),:)

[Sami]

thanks a lot !!! it works

[Jan]

+1: I *must* vote your answer: it is too obvious that it is the best answer in my opinion. :-)