Comparing first n digits
4 次查看(过去 30 天)
显示 更早的评论
Hi ,
I have two columns of numbers A and B. A is 9 digits and B is 8 digits. How can I find the row in B that matches A(i) in a loop (i=1:length(A))
3 个评论
Rik
2017-10-25
I would recommend not using a loop. If you have stored the number in a number format, just divide the A by 10 and floor it to convert to 8 digits. If you have it as a string, just remove the last character.
Then you can use ismember to do the work. ismember can be slow, so looking for alternative methods can be worthwhile if that is the bottleneck in your code.
采纳的回答
Walter Roberson
2017-10-25
[tf, Bidx] = ismember(fix(A/10), B);
Now, tf(K) tells you whether A(K) had a match in B or not, and if tf(K) is true then Bidx(K) tells you which entry in B matched.
0 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Type Identification 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!