Community

Thank you Ben, I seriously appreciate your help.

Unfortunately there are about 10,000 lines in this text, it seems 80 percent of it is cruft.

I have now abandoned the project for a couple of reasons:
1: The data input is crap
2: The insurance company behind this don't seem to care, although it ...

I am so sorry about the delay in in responding:

I believe is what I need is: Devenny, B; 04/14/09;

That is Name, Initial, Date, where name and initial are Xxxxx, X, and the date is a separate field. (Using ";" as the delimiter.)

I realy have to thank you for your generous assitance; I grew up in ...

Thank you so much, I did manage to make that work.

How would I pare this into two fields:

No, unfortunately that doesn't get it; comes up with cannot find regular expression.

Unfortunately these numbers occur in the midle of a line:

NewRecord; AL 69230 FLEET GROUP PHPL2000097 05/01/08 05/01/09 PHAL08060333806 05/18/08 0 0 0 0 0 0 0 0 Catastrophe: Claim Status: OP

NewRecord; AL AP ...

I am trying to parse a large txt file produced from a PDF.

Unfortunately the PDS 'save as text' system was inconsitent.

Within the file there are strings of random numbers, like:
0 0 0 0 5,107 0 0 -5,107
0 0 0 0 5,277 0 0 -5,277

As you can see, the second row is double spaced which would allow me ...