As there is (apparently) no way of knowing the lenght of C2 and D2, there
appears to be no way of extracting them generically.

In your example c2 & d2 =131 and therefor logic says c2=13 and D2=1

If the last digits (having extracted A2 & B2) were 12345, then ...

C2 D2
12 345
123 45
1234 5

How can we determine which of these it is?


"Jules" wrote:

Thanks John, so much for answering.

The first ten in A2 are consistent, B2 is consistent, c2 can be from two to
five digits and d2 can be from 1 to three.

I've extracted all but the one I need which is a quantity...one to 400...

So, with what is left the first order would be the first 2-4 numbers and
then (what I need) the one to three number I need right next to the text
string.

Does that answer everything?

Thanks for the help.
--
Jules


"John Bundy" wrote:

A couple questions I need answered first, you show values from A2,B2 etc, do
these numbers have meaning? Are they always the same length. Is there a
consistent amount of numbers before the first letter? and finally you say
there could be up to 3 numbers that you need, how do you know how many you'll
need?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Jules" wrote:

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