de-duping a file

[Jay Ashworth]

----- Original Message -----
> From: scooter6 at gmail.com

> I have a rather large file that may or maynot have multiple records
> based on our 'Account Number' - there is also a 'date' field in this file
> 
> I'm trying to de-dup the file - that is, if there are more than 1 record
> for 'each' account number, it should only keep the most current record.
> If there is only one record for said 'Account Number' it should keep it and
> do nothing - if there are multiple (2 or more) records for 'Account Number'
> it should keep the most current dated one

Write a process only report that deletes the current record if it detects a 
duplicate from the previous, and run it against an index that is account
number (in either order), and date *in descending order*.

If that's not enough hint, chime back in.

Cheers,
-- jra
-- 
Jay R. Ashworth                  Baylink                       jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates     http://baylink.pitas.com         2000 Land Rover DII
St Petersburg FL USA               #natog                      +1 727 647 1274