[thelist] removing redundant entries

D. Bruce Saurer g1notami at zoominternet.net
Sun Oct 6 12:49:01 CDT 2002


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





More information about the thelist mailing list