Help with regexp to extract data

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,

Answer 1

[Stephen23]

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);

[Pete sherer]

thanks very much