Help with regexp to extract data

Question

Pete sherer 2021-8-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/891677-help-with-regexp-to-extract-data

评论： Pete sherer 2021-8-3

Hi

I need help extracting the text and number or text before and after the "_". When an underscore is not present, then the whole text is considerd the latter part.

tdata= {'W1W','W1W 7','W1W 8','AZ_85262','CA_90032','CA_90045'};

the answer should be

fr = {'','','','AZ','CA','CA'}; % first portion
ed = {'W1W','W1W 7','W1W 8','85262','90032','90045'}; % the end portion

Thanks,

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2021-8-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/891677-help-with-regexp-to-extract-data#answer_759977

编辑：Stephen23 2021-8-3

在 MATLAB Online 中打开

tdata = {'W1W','W1W 7','W1W 8','AZ_85262','CA_90032','CA_90045'};
tkn = regexp(tdata,'^(.*?)_?([^_]*)$','tokens','once');
tkn = vertcat(tkn{:})
tkn = 6×2 cell array
    {0×0 char}    {'W1W'  }
    {0×0 char}    {'W1W 7'}
    {0×0 char}    {'W1W 8'}
    {'AZ'    }    {'85262'}
    {'CA'    }    {'90032'}
    {'CA'    }    {'90045'}
fr = tkn(:,1);
ed = tkn(:,2);