Extracting Numbers froma Text String
Hi...I have a problem I've been working on for a while now...to no avail.
a2=200865346120565131TED STOCK THIGH HIGH XL 3922
I'm managed to get to
a2=2008653461
b2=20565
c2=13
d2=131ted stock thigh high xl 3922
e2=ted stock thigh high xl 3922
Problem is D2 - I need the one after the three...
It is not consistent in the database...
But what is consistent is I need the one right before the text begins (some
times it may be up to three numbers) all located before the text.
Any help would be great!
Thanks
jules
01.20.09
--
Jules
|