The Wholesale Forums

[ara-uk]

Is there any FREEWARE program which I can use to delete duplicate email addresses from a text file?

I currently have over 400 subscribers to my mailing list, and I'm sure there's a few duplicates in there somewhere!

Email addresses are in the following format:
a@a.com, b@b.com if that helps

[JMW]

Copy the email addresses into MS Excel and then use the advanced filter:

1. Select all the rows, including the column headers, in the list you want to filter.Click the top left cell of the range, and then drag to the bottom right cell.
2. On the Data menu, point to Filter, and then click Advanced Filter.
3. In the Advanced Filter dialog box, click Filter the list, in place.
4. Select the Unique records only check box, and then click OK.The filtered list is displayed and the duplicate rows are hidden.
5. Copy the list back into the text file

If you dont have MS Excel im sure OpenOffice can perform the same function and its free.

Hope this helps.

John.