[thelist] removing redundant entries

Anthony Baratta Anthony at Baratta.com
Sun Oct 6 11:10:00 CDT 2002


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."




More information about the thelist mailing list