Delete Duplicate Records based on one field

Forum for DBF Commander discussing.

Delete Duplicate Records based on one field

Postby danlapp » Sun Jan 24, 2021 9:24 pm

I have a Foxpro file that contains records with some duplicate customer numbers. I want to delete duplicate records that have the same customer number, leaving only one unique record for each customer. I don't care which duplicate record are deleted or kept, as long as the resulting file has the same structure (data and index) as the original.

What commands in DBF Commander can process deleting the duplicates?
Do I have to be concerned about retaining the original file's structure (data and index), especially if a new file is created?

Thanks,
Dan L.
danlapp
 
Posts: 5
Joined: Fri Nov 08, 2019 10:17 am

Re: Delete Duplicate Records based on one field

Postby Admin » Mon Jan 25, 2021 9:57 am

Dan,
please try to use Tools -> Delete Duplicates command.
Best regards,
Oleg Zhechkov
User avatar
Admin
Site Admin
 
Posts: 124
Joined: Wed Apr 21, 2010 7:27 pm

Re: Delete Duplicate Records based on one field

Postby danlapp » Tue Feb 09, 2021 5:55 am

Thanks. Very useful.
danlapp
 
Posts: 5
Joined: Fri Nov 08, 2019 10:17 am


Return to DBF Commander Professional

Who is online

Users browsing this forum: No registered users and 6 guests

cron