Matching the first two words
조회 수: 2 (최근 30일)
이전 댓글 표시
Hi,
I have two cell arrays A and B. A(1)= American Express Corporation B contains cells with the following string "AMERICAN EXPRESS CO" the two companies are the same but they won't match unless I ask to match the first two words (with case insensitive matching). How can I find the cells in B that matches A(1) based on the first two words only? Best, Wesso
댓글 수: 0
채택된 답변
Azzi Abdelmalek
2015년 6월 8일
A={'American Express Corporation','American1 Express Corporation','American2 Express Corporation'}
B={'AMERICAN EXPRESS CO','AMERICAN3 EXPRESS CO', 'AMERICAN1 EXPRESS CO' }
a=regexp(A,'\s+','split')
b=regexp(B,'\s+','split')
a1=upper(cellfun(@(x) [x{1},x{2}],a,'un',0))
b1=upper(cellfun(@(x) [x{1},x{2}],b,'un',0))
Now you can compare your companies
댓글 수: 4
Guillaume
2015년 6월 8일
regexp(str, '$[A-Za-z]+', 'match')
will return only the beginning of a string up to the first non-letter.
However, rather than making the string matching algorithm more and more complicated, I would rather focus my efforts in making sure the inputs were properly formatted in the first place.
추가 답변 (0개)
참고 항목
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!