Please help! - Duplicate records

[PromoPunch]

I have filemaker 6 and have a DB with about 90,000 records. A ton of them are duplicates. Is there something out there that will remove all the dupes and leave only 1 copy of the record?

Thanks!

[PromoPunch]

Hi again,

I am willing to PAY for a script written in either 6 or 8 that will do this. This database is a product feed for google's froogle. I have 90,000 records, and about 40,000 are probably duplicates. If the "Name" field is the same i want all but 1 removed.

If you can do this, please contact me asap. It is urgent. [email protected]

Thanks!

[Raybaudi]

Hi

you haven't to PAY anything...

but only to read post like this one !

[Søren Dyhr]

Yes self-joins could do it, but it would probably be faster to export summaries, make a summary field where you use Count and the target-field is Name in your base. Sort the database on Name and use Export Records, choose the format to be Filemaker Pro, press the Archive button, map all fields except the summary field to the receiving file-format, press the "summarize by" button and select the name field ...then are we done press Export. Open the newly created file for inspection if every thing seems alright go to the original empty it and reimport it from the newly created file (observing a proper mapping of-course)

--sd