Arrange the data by year and format.

[pesteness]

Make believe your MAIN FILE had only this in it...

Mercedes model - 300CE Coupe E Class 124.052 104.992 from 1993-1993
Mercedes model - 300E 3.2 E Class 124.032 104.992 from 1993-1993
Mercedes model - 190E 2.3 201.024 102.985 from 1984-1986
Mercedes model - 300CD Turbo 123.153 617.952 from 1982-1983

What would the ACTUAL FILE for them look like?

I see, got it.

example this, Mercedes model - 190E 2.3 201.024 102.985 from 1984-1986

this should be look like:

Make=Mercedes Model|Model=190E|Year=1984|Notes=2.3 201.024 102.98
Make=Mercedes Model|Model=190E|Year=1985|Notes=2.3 201.024 102.98
Make=Mercedes Model|Model=190E|Year=1986|Notes=2.3 201.024 102.98

the 2.3 comes with the notes

Thank you.

[Rick Rothstein]

I see, got it.

example this, Mercedes model - 190E 2.3 201.024 102.985 from 1984-1986

this should be look like:

Make=Mercedes Model|Model=190E|Year=1984|Notes=2.3 201.024 102.98
Make=Mercedes Model|Model=190E|Year=1985|Notes=2.3 201.024 102.98
Make=Mercedes Model|Model=190E|Year=1986|Notes=2.3 201.024 102.98

the 2.3 comes with the notes

Thank you.

Okay, now what would the other three look like in the ACTUAL FILE (I do have a reason for asking about them also)?

[pesteness]

Okay, now what would the other three look like in the ACTUAL FILE (I do have a reason for asking about them also)?

yes, sure.

Make=Mercedes Model|Model=300CE Coupe E Class|Year=1993|Notes=124.052 104.992

Make=Mercedes Model|Model=300E E Class|Year=1993|Notes=124.032 104.992

Make=Mercedes Model|Model=300CD Turbo|Year=1982|Notes= 123.153 617.952
Make=Mercedes Model|Model=300CD Turbo|Year=1983|Notes= 123.153 617.952

just please disregard (3.2) the liters, i already know now what's your point.

Thanks,

[pesteness]

then this should be,

Make=Mercedes Model|Model=190E|Year=1984|Notes=201.024 102.98
Make=Mercedes Model|Model=190E|Year=1985|Notes=201.024 102.98
Make=Mercedes Model|Model=190E|Year=1986|Notes=201.024 102.98


Thanks,

[Rick Rothstein]

just please disregard (3.2) the liters, i already know now what's your point.

Actually, my point is that I cannot disregard the 3.2 because I won't be specifically looking for it. There is no way I can write a program that looks for specific things because there are probably too many of them for existing models and who knows what there will be for future models. The best I can do, in the absence of proper delimiters is to find the most common "shape" to your data (that is, the juxtaposition of numbers and letters) and try to break the text apart based on that. This is why I asked the question I did... because I do not know your product line at all (things about it that you take for granted are completely unknown to me). Okay, I think you have given me enough to work with, now let me digest it and then see if I can come up with a strategy to handle... that may take awhile, so please be patient with me.

[pesteness]

sure no problem, thanks for the help. god bless.