I have a pipe delimited text file that I use as a mailing list I have information in the following format:
lastname|firstname|company|email|state|date I am using it as a mailing list. However, over the last half year, it has gotten pretty big, and has some duplicates in it. For reporting sake, I would like to delete the duplicate records based on email addresses. If you sign up three times, I only want to keep your first record in there. I want this file: jones|Bob|Acme1|[EMAIL PROTECTED]|GA|2/25/2002 jones|Bob|Acme1|[EMAIL PROTECTED]|GA|2/28/2002 smith|Jan|Acme2|[EMAIL PROTECTED]|FL|3/1/2002 johnson|Salley|Acmeshop|[EMAIL PROTECTED]|TN|4/5/2002 SMITH|JAN|ACME2|[EMAIL PROTECTED]|FL|5/2/2002 to change to this file: jones|Bob|Acme1|[EMAIL PROTECTED]|GA|2/25/2002 smith|Jan|Acme2|[EMAIL PROTECTED]|FL|3/1/2002 johnson|Salley|Acmeshop|[EMAIL PROTECTED]|TN|4/5/2002 Can anyone point me in the right direction? I appreciate any help. Thanks, Andrew -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
