At 11:59 AM 10/6/2002, D. Bruce Saurer wrote: >Anthony Baratta wrote: > > If your problem is truely redundant lines, suck them all into a new > > DB. If your DB Engine supports "Select Into", you could then select > > all the distinct records and move them into a new table. > >All I have is the deliminated file. My thought was to remove the dupes >using regex in TextPad. I've no idea what the original DB Engine is. >I'll ask and explore it from that angle. If you have Access 2000, you might find it easier to use SQL and Access to filter and massage the data than to use RegEx. --- Anthony Baratta President Keyboard Jockeys "Conformity is the refuge of the unimaginative."