Matching based on the first word

Question

Danielle Leblance 2017-11-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/366212-matching-based-on-the-first-word

编辑： Jan 2017-11-10

Hi,

I have two cell arrays A and B where each contains companies names: for example A contains "Biotech Capital Corp" while B contains the same company but listed differently "BIOTECH CAP CORP". Can I match A and B based on the first word in the text? I mean can i write a code that tells that "Biotech Capital Corp" matches "BIOTECH CAP CORP" based on teh first word in the two strings "biotech" ?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jan 2017-11-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/366212-matching-based-on-the-first-word#answer_290357

编辑：Jan 2017-11-10

在 MATLAB Online 中打开

A_list = {'Biotech Capital Corp', 'Apple something', 'tesla something else'};
B_list = {'Volvo Car AB', 'BIOTECH CAP CORP', 'TESLA by Elon Musk'};
A1 = strtok(A_list, ' ');
B1 = strtok(B_list, ' ');
[LiA, LocB] = ismember(lower(A1), lower(B1));   % Or the other way around

Or with FEX: CStrAinBP:

[AInd, BInd] = CStrAinBP(strtok(A_list), strtok(B_list), 'i')

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

per isakson 2017-11-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/366212-matching-based-on-the-first-word#answer_290342

编辑：per isakson 2017-11-10

在 MATLAB Online 中打开

Yes, try this

match = cssm()
match =
     0     1     0
     0     0     0
     0     0     1

A_list items on the rows and B_list on the columns, i.e.

the first item in A_list matches the second item in B_list.
the fourth item in A_list matches the fourth item in B_list.

where

function    match = cssm()
    A_list = {'Biotech Capital Corp', 'Apple something', 'tesla something else'};
    B_list = {'Volvo Car AB', 'BIOTECH CAP CORP', 'TESLA by Elon Musk'};
    match = false( length( A_list ), length( B_list ) );
    for jj = 1 : length( A_list )
        a1  = regexp( A_list{jj}, '\<\w+\>', 'once', 'match' );
        xpr = sprintf( '\\<%s\\>', a1 );
        cac = regexpi( B_list, xpr );
        %
        match( jj, : ) = cellfun( @(pos) not(isempty(pos))&&pos==1, cac );
    end
end