MATLAB: Extract numbers from a cell array

arrayextractregular expression

Hi I have a 1×19399 cell array all in the format of:
'Tick("TSP1",4285,1,{"52":"20101101005933863","TIME":"1288573173.867"})'
'Tick("TSP1",4287,1,{"52":"20101101005933869","TIME":"1288573173.869"})'
…… (19399 OF THEM)
I WANT TO TAKE THE NUMBERS AFTER THE TSP1 AND CREATE A NEW 1X19399 ARRAY OF NUMBERS CONTAINING 4285, 4287 ETC…. JUST THE 4 DIGIT NUMBER AFTER TSP1. ALL ARE IN THE SAME FORMAT.
thanks

Best Answer

N = cellfun(@(x) str2double(x(13:16)),G) % G is your cell array.
Related Question