How do I extract email addresses from a text file?

Discussion in 'Site & Server Administration' started by jhsutton, Aug 1, 2009.

0
  1. #1
    Hi,

    Recently, one of my forums went down and I thought I'd lost everything. Last week, however, it came back, so I copied all data from the members list to a text file. Is there a quick way to extract just email addresses from this list?

    thanks in advance
     
    jhsutton, Aug 1, 2009 IP
  2. JasonAnderson

    JasonAnderson Peon

    Messages:
    58
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You may want to copy your text file to a spreadsheet. Then sort from there.

    If you don't have MS Excel you may want to consider OpenOffice.org They have an open source version.
     
    JasonAnderson, Aug 1, 2009 IP
  3. bskelhorn

    bskelhorn Peon

    Messages:
    58
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    If the text file is delimited i.e data, email, data then it can be done quite quicky as said above using excel. If you want you can PM me and I can do the data work for you. I am a data manager for a mailing house in the UK. Just let me know.
     
    bskelhorn, Aug 1, 2009 IP
  4. onedee

    onedee Peon

    Messages:
    43
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    This is a very tedious job - PM me the file with the emails and I will filter out the emails for you and send it back
     
    onedee, Aug 1, 2009 IP
  5. jhsutton

    jhsutton Peon

    Messages:
    374
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I have tried to use MS Excel, but each line of data appears in one cell.

    their username-their email address-628 26 Dec 2008 29 Jun 2009 Yes

    -- the whole of the above appears in one cell only, rather than spread over a number of cells. Is it possible to filter within a cell?
     
    jhsutton, Aug 1, 2009 IP
  6. bskelhorn

    bskelhorn Peon

    Messages:
    58
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    If you send over the file I can sort this for you in a snap. Just let me know.
     
    bskelhorn, Aug 2, 2009 IP
  7. blue_angel

    blue_angel Well-Known Member

    Messages:
    1,174
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    130
    #7
    Very simple copy paste data to excel -> Data -> Convert text to columns -> separate char set - as used for the fields else send me file to convert for you :)
     
    blue_angel, Aug 2, 2009 IP