Adam, Andrew - thanks heaps for your suggestions.
Adam, I have a vague idea of Terminal but I'm not overly familiar with
command line prompts and all that stuff, so I wasn't really sure what
to do with your suggestion, or how I could use it in conjunction with
a file full of email addresses.
Andrew, I had a look at your sample spreadsheet - very resourceful and
inventive. The file I have complicates things a little by having
things like commas after email addresses, most lines having one email
address but some having two, etc. I'll take you up on your generous
offer if it's still open. You could probably do in 5 minutes what it
would take me all day and still get wrong. It's not a confidential
list. I'll email through separately.
Cheers, Steven
On 01/07/2009, at 3:58 AM, Andrew Bignell wrote:
Steven
You could this in a spreadsheet like Excel or Apple's Numbers. The
trick is after opening or importing the text doc, is to sort them by
the email address field and then add a formula in a new column that
tests to see if the email in the cell directly above is the same
(the first cell will be empty). If it's the same (duplicate) the
formula returns the value of 1, and 0 if false. Now you have to sort
all the columns on this new column and all the 1's will be the
duplicates. BUT before you do this, you have to convert the column
from a formula to just the value of 1 or 0 FIRST. To do this Edit-
Copy and then Edit-Paste Special and choose Values.
I have attached an excel doc (sent direct to your email only) with a
sample formula for you to work with, but if you get stuck I can do
it for you (but I know it is email address i.e personal data) but I
thought I would offer any way. Duplicate the text doc before you
start and work on the copy, just in case.
Regards
Andrew Bignell
Email: abign...@iinet.net.au
Mobile: 0414 349 002
On 01/07/2009, at 3:43 AM, Adam Hewitt wrote:
If it only text then you can do it in the terminal:
'cat textfile.txt | uniq > newtextfile.txt'
Adam
Sent from my iPhone
On 01/07/2009, at 5:06 AM, Steven Knowles <emai...@knowles.net.au>
wrote:
I have a text document full of email addresses, maybe 5,000 of
them, but many are duplicated. I want to strip out the duplicates.
I came across "eMail Extractor", but before I go down that route
and pay for something that I will most likely use once for a single
job, does anyone know of alternative freeware which will do the
same job?
Or if someone has it already I could email the document through if
it's a simple enough task.
Cheers, Steven
-- The WA Macintosh User Group Mailing List --
Archives - <http://www.wamug.org.au/mailinglist/archives.shtml>
Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml>
Unsubscribe - <mailto:wamug-unsubscr...@wamug.org.au>
