combining information of 2 cells
显示 更早的评论
Hello,
I have a reference cell(ref) which contains many postal codes and the corresponding geographic coordinate for each postal code. I wish to find the geographic coordinate for each postal code in cell A by using ref Cell. So I want to get B. Is there any way to do it *without making loop * over the elements in A?
ref={{'m3m1f1';'y9h5g5';'u8h1h5'} {50.00;50.44;30.98}}
A={{'y9h5g5';'m3m1f1'}}
B={{50.44;50.00}}
thanks in advance!
1 个评论
Matt Fig
2012-9-11
Your ref cell looks wrong. You have 3 postal codes but 4 coordinates. Please correct this and post something I can copy/paste into the command window without editing...
采纳的回答
ref = {{'m3m1f1';'y9h5g5';'u8h1h5'}; {50.00;50.44;30.98}};
A = {'y9h5g5';'m3m1f1'};
[J,J] = ismember(A,ref{1}); % Or A{1} if you need to keep {{}}.
B = ref{2}(J) % Or B = {ref{2}(J)} if you need to have{{}}.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
