Google Answers Logo
View Question
Q: Parsing Email Addresses ( Answered 5 out of 5 stars,   0 Comments )
Subject: Parsing Email Addresses
Category: Computers > Software
Asked by: newhorizons123-ga
List Price: $15.00
Posted: 28 Oct 2005 04:34 PDT
Expires: 27 Nov 2005 03:34 PST
Question ID: 585983
I have an email list of several thousand subscribers to my email
newsletter.  I am wondering if there are any programs or software that
will let me sort these addresses in domain name order and/or which
will tally the number of subscribers by domain name.  For example, it
would take an address such as and sort/list it by
"".  I'm not looking for anything elaborate, just
something that'll let me see where my subscribers are coming from.

Request for Question Clarification by pafalafa-ga on 28 Oct 2005 04:59 PDT
If you are familiar with a spreadsheet program like Excel, this is a
pretty straightforward task.

Save your list as a .txt file.

When you open that file as a spreadsheet, you'll get a pop-up box
asking how you want to import the file.  Identify the @ sign as a
character used to separate columns (in other words, 'joe' will show up
in the first column, and '' will be in a separate column).

You can then sort the spreadsheet data by domain names, to easily
count up all the '' addresses.

Make sense?

Let me know if that works out for you.


Clarification of Question by newhorizons123-ga on 28 Oct 2005 08:57 PDT
Yes, that works.  Great solution!
Subject: Re: Parsing Email Addresses
Answered By: pafalafa-ga on 28 Oct 2005 09:01 PDT
Rated:5 out of 5 stars

Hey, that's great.

Let me know if there's anything else you need on this one.


search strategy --- None.  Used my knowledge of text management.
newhorizons123-ga rated this answer:5 out of 5 stars and gave an additional tip of: $5.00
Super answer.  A solution to the problem was identified immediately.

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy