Thanks for the replies. I found a dos utility (dedupe12.exe) written by John Augustine http://www.eunet.bg/simtel.net/msdos/txtutl.html that was just what I needed again thanks, bruce g1notami at zoominternet.net Anthony Baratta wrote: > 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."