extract numbers from a cell array

Hi I have a 1x19399 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

Answer 1

[Matt Fig]

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

[Mate 2u]

Thanks Matt! Reliable as always!