5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

Email address extract

by affdaft
4 replies
Hi guys,

Probably a basic question, not entirely sure. How do you extract exact email addresses from your lists. Say I have a .TXT or .CSV file list and have various email address in there. But I am looking for only gmail addresses for example how do I extract just gmail addresses?

Can be from notepad TXT file or Excel as can put the file on both just wondering how to do this?

Cheers
#address #email #extract
  • Profile picture of the author DIABL0
    You need a list manager.

    Also, keep in mind that you will need to be able to do more than just filtering, etc...

    When sending CPA offers you are going to need to run MD5 suppression lists against your data and not send to any matching records.

    Some suppression lists can be 1 million plus in size and if you are using an ESP, you don't want to be uploading such a huge list. So you want a program that will write matches and you can then upload a custom suppression list that only contains emails that exist in your data.

    Even if you are not using ESPs and you have a mailer that supports suppression files. You should still keep them minimal size.

    So make sure you can run MD5 suppression list and it has the ability to remove the matches or write the matches.
    Signature
    How to Build LARGE EMAIL LISTS on a Budget and MONETIZE Like a PRO
    20+ Years Exp . . . . . . . . . . . . Email - CPA - PPL
    {{ DiscussionBoard.errors[11053711].message }}
  • Profile picture of the author ProducerK
    Send Safe List Manager
    Opt In List Manager

    You can find both of these with some google searches.
    Signature
    EMAIL & SMS MARKETING | DATA & LEADS SALES | SYSTEMS SETUP | EXPERT CONSULTING
    LeadsPlusData.Com | PM For Skype, Telegram, Signal, WhatsApp, And More....
    {{ DiscussionBoard.errors[11053935].message }}
  • Profile picture of the author topcoder
    You can use a formula in excel to split the email addresses up by domain name.

    In Column B, use this formula

    =RIGHT(A1,LEN(A1)-FIND("@",A1))

    Assuming Column A has the email address.

    Then after that you can just do a basic filter on column B and select the domain you want.

    Or you can just do a text filter on Column A for contains "@gmail.com"
    {{ DiscussionBoard.errors[11056832].message }}
    • Profile picture of the author affdaft
      Thanks a lot man I will try this.
      {{ DiscussionBoard.errors[11056849].message }}

Trending Topics