Eliminating duplicate records from a flat file

How to eliminate duplicate records from a flat file?

    Requires Free Membership to View

I would use two choices here. One, write a Perl program to perform this activity. Two, load the data into an Oracle database with SQL*Loader. Then remove the duplicate records with a DELETE statement. Finally, dump the records back to a flat file.

This was first published in January 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.