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!