beatsie - 3:23 pm on Jan 9, 2004 (gmt 0)

Ok i just tried your suggestion for the moment jatar_k.

Your suggestion works the way i described the problem, so many thanks for that.
But, I had another look at the source data, and the data is not delimited by ¦

It looks like each piece of data i want is actually on a new line.

What it looks like is one field with many lines within that field.It's hard to accurately describe, so i can email a screenshot if required.

I tried using '\n' instead of '¦' but that did not work,.

Any advice appreciated.