MATLAB Answers

find in structure a certain string

3 views (last 30 days)
raw is a cell.
I would like to find the identification number in the example which is 13161509800019, but I only want the cell that contains 1-2-3, as the cell below it contains a trailing 4-5-6. Also how can I do that for any number of identification numbers containing 1-2-3 column 1 excluding first row 'SERIAL'?

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 15 Apr 2016
Edited: Azzi Abdelmalek on 15 Apr 2016
C={'serial';'123456 1-2-3';'1452145 4-5-6';'745841 3-2-4';'85471245 1-2-3'}
C=C(2:end);
idx=~cellfun(@isempty,regexp(C,'1-2-3'))
D=C(idx)
out=regexp(D,'.+(?=1-2-3)','match')
out=str2double([out{:}])
  2 Comments
Leonardo Wayne
Leonardo Wayne on 18 Apr 2016
never mind. I have solved it.

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!