what software can do this?

Discussion in 'Databases' started by unlisted80, Sep 27, 2006.

0
  1. #1
    i have a large database export from phpmyadmin into text file. i am looking for some kind software can extract all the email into excel or words format

    thanks advance
     
    unlisted80, Sep 27, 2006 IP
  2. digitome

    digitome Peon

    Messages:
    411
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Google "extract emails" and try the first link, the software is actually called Extract Emails and should do the job for ya.
     
    digitome, Sep 27, 2006 IP
  3. rosytoes

    rosytoes Peon

    Messages:
    230
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    can't you just run a perl or php script on the text file? shouldn't take more than a few lines of code.
     
    rosytoes, Sep 28, 2006 IP
  4. unlisted80

    unlisted80 Peon

    Messages:
    644
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #4
    how you do that?


    i try many software and is not working :(
     
    unlisted80, Sep 28, 2006 IP
  5. serverresponse

    serverresponse Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    You can also use a harvest program for massive email databases that will pull the string search of emails. Google it and you will find tons of programs that will extract the emails from the datebase and or file.

    -Sean
    serverresponse.com
     
    serverresponse, Sep 28, 2006 IP
  6. rb3m

    rb3m Peon

    Messages:
    192
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #6
    That's the sort of thing I like using Rebol www.rebol.com for:

    rebol []

    emails: ""
    bigfile: read %bigfile.txt
    words: parse/all bigfile " ,;'"
    foreach word words [
    if found? find word "@" [ insert emails join word "," ]
    ]
    write %emails.txt emails

    This is a very simple and unsofisticated script that produces a csv file that you can then load into excel. Quick and dirty but gets the job done.
     
    rb3m, Sep 28, 2006 IP
  7. khasmoth

    khasmoth Well-Known Member

    Messages:
    1,211
    Likes Received:
    96
    Best Answers:
    0
    Trophy Points:
    165
    #7
    If you can download an excel file of your db I can help you extract all the email into excel.
     
    khasmoth, Oct 3, 2006 IP
  8. Pat Gael

    Pat Gael Banned

    Messages:
    1,331
    Likes Received:
    68
    Best Answers:
    0
    Trophy Points:
    0
    #8
    there are different freeware and shareware programs that can extract emails from any file and even from websites.

    Try www.download.com to find them out
     
    Pat Gael, Oct 3, 2006 IP
  9. sadcox66

    sadcox66 Spirit Walker

    Messages:
    496
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Import your text file into Excel then do what you want
     
    sadcox66, Oct 9, 2006 IP
  10. DidierE

    DidierE Well-Known Member

    Messages:
    1,815
    Likes Received:
    50
    Best Answers:
    0
    Trophy Points:
    145
    #10
    Export your database to an excel spreadsheet instead of a normal txt file
    Than open that file in excel and copy the table with all the email addresses in it.
    Copy past to whatever you want and you're done ;)

    Didier
     
    DidierE, Oct 9, 2006 IP
  11. Dennis de Jong

    Dennis de Jong Guest

    Messages:
    198
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #11
    DId you find a solution? I can digg up an old tool that could do that.
     
    Dennis de Jong, Nov 6, 2006 IP
  12. kartik786

    kartik786 Well-Known Member

    Messages:
    1,906
    Likes Received:
    61
    Best Answers:
    0
    Trophy Points:
    170
    #12
    kartik786, Nov 6, 2006 IP