Fetching variable from another variable

I have two sets of variables
A=
'yar12' 'hi' 'hello' 'hi' 'hello'
'yar13' hello' 'hello' 'hi' 'hello'
'yar14' 'hi' 'hi' 'hi' 'hello'
'yar15' 'hello' 'hi' 'hi' 'hi'
'yar16' 'hello' 'hi' 'hi' 'hello'
'yar17' 'hi' 'hi' 'hi' 'hi'
and
B=
'yar13' hi' 'hello' 'hello' 'hello'
'yar16' 'hi' 'hello' 'hi' 'hello'
'yar17' 'hello' 'hi' 'hello' 'hi'
The size of both matrix are different by comparing first column,i want to fetch values(2nd to 5th column) from A correspnding to 1st column of B,So i need output as
C=
'yar13' hello' 'hello' 'hi' 'hello'
'yar16' 'hello' 'hi' 'hi' 'hello'
'yar17' 'hi' 'hi' 'hi' 'hi'
PLease provide assistance

 Accepted Answer

[tf, idx] = ismember(B(:,1), A(:,1));
C = A(idx,:);

2 Comments

C = A(ismember(A(:,1),B(:,1)),:);
Thanks a lot Andreei

Sign in to comment.

More Answers (0)

Categories

Find more on Operators and Elementary Operations in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!