1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How can i extract 1,000 CSV Files??

Discussion in 'Black Hat SEO Tools' started by crisis23, Jul 23, 2009.

  1. crisis23

    crisis23 BANNED BANNED

    Joined:
    Jan 6, 2009
    Messages:
    253
    Likes Received:
    79
    hey guys how can i extract this CSV files??

    i have about 1,000 files i need to combine

    its killing me if i do it 1,000 times copy&paste
     
  2. guschman

    guschman Registered Member

    Joined:
    Dec 18, 2008
    Messages:
    55
    Likes Received:
    10
    you want to extract whats inside into one txt-file(??) or you want to merge them to one big csv?
     
    • Thanks Thanks x 1
  3. crisis23

    crisis23 BANNED BANNED

    Joined:
    Jan 6, 2009
    Messages:
    253
    Likes Received:
    79
    yeah there are emails in the csv files..

    i want to merge 100 CSV files in to 1 big csv file...

    is that possible??
     
  4. guschman

    guschman Registered Member

    Joined:
    Dec 18, 2008
    Messages:
    55
    Likes Received:
    10
    definitly possible easily. only depends on how the output should look like.

    as you say it`s csv: is there additional data related to each email-adress (like name, timestamp whatever) that should be kept with the email?
    or do you only want to have the emails in plain-text?

    (depending on your answer i can suggest you a way to do it. plain-text will be easier for you - csv will be little bit more difficutl as i dont expect you to have a good tool for that)
     
  5. pyronaut

    pyronaut Executive VIP

    Joined:
    Dec 9, 2008
    Messages:
    1,229
    Likes Received:
    1,422
    You could use "Firebird Email Manager" link is in my sig, (Same site, different page etc).

    Although you will still have to do it one at a time, it will be much faster then copy and pasting.

    You will just have to select the files one at a time. Just check it out anyway.
     
    • Thanks Thanks x 1
  6. Kamek

    Kamek Newbie

    Joined:
    Jul 9, 2008
    Messages:
    20
    Likes Received:
    1
    If you have linux you could use cat file1 >> file2 or similar, or pick a programming language (i recommend python or perl) and it should be stupidly easy. Could probably do it with vbscript or a bat too if you run windows.
     
    • Thanks Thanks x 1
  7. crisis23

    crisis23 BANNED BANNED

    Joined:
    Jan 6, 2009
    Messages:
    253
    Likes Received:
    79
    yea but the only format is

    email1@mail.com
    email2@mail.com
    email3@mail.com
    etc!


    ok ill check it out thanks bro.. but someone told me there's a software that does this you just combine 1,000 CSV files.. but it seems i really cant find one

     
  8. BozoClown

    BozoClown Junior Member

    Joined:
    Jan 4, 2009
    Messages:
    150
    Likes Received:
    106
    Merge all data from the csv files into a single file all.csv

    1) Windows Start Button | Run
    2) Type cmd and hit enter
    3) Go to the folder with the CSV files (for help enter "help cd")
    4) Type copy *.csv all.csv and hit enter to copy all data in the files into all.txt.
    5) Type exit and hit enter to close the DOS window
     
    • Thanks Thanks x 1
    Last edited: Jul 23, 2009
  9. forgot

    forgot Jr. VIP Jr. VIP Premium Member

    Joined:
    May 3, 2008
    Messages:
    936
    Likes Received:
    706
    Location:
    BlackhatWorld
    There is a software out there which meges all csv/excel files in one. Just search for merge csv files on G.
     
    • Thanks Thanks x 1
  10. crisis23

    crisis23 BANNED BANNED

    Joined:
    Jan 6, 2009
    Messages:
    253
    Likes Received:
    79
    hey bro im having trouble with #3.. does the folder needs to be in the C drive??



    yea bro i did search.. but all of them doesnt even work or u need to pay for the software..

     
  11. pasdoy

    pasdoy Power Member

    Joined:
    Jul 17, 2008
    Messages:
    727
    Likes Received:
    231
    make your own macro.
     
  12. crisis23

    crisis23 BANNED BANNED

    Joined:
    Jan 6, 2009
    Messages:
    253
    Likes Received:
    79
    hey bro when i hit load it actually doesnt read the csv files??

    am i doing something wrong??

    [​IMG]


     
  13. BozoClown

    BozoClown Junior Member

    Joined:
    Jan 4, 2009
    Messages:
    150
    Likes Received:
    106
     
    • Thanks Thanks x 1
  14. crisis23

    crisis23 BANNED BANNED

    Joined:
    Jan 6, 2009
    Messages:
    253
    Likes Received:
    79
    arghh bro im so confused with DOS i cant make it work ;(

     
  15. BozoClown

    BozoClown Junior Member

    Joined:
    Jan 4, 2009
    Messages:
    150
    Likes Received:
    106
    I use linux so I haven't tested it, but from my experience it should work. I can merge the files for you if the zipped file is relatively small.
     
    • Thanks Thanks x 1
  16. ttriplesoft

    ttriplesoft BANNED BANNED

    Joined:
    Jul 11, 2009
    Messages:
    18
    Likes Received:
    6
    Send all file to me, i will do it manually Thanks
     
  17. the_demon

    the_demon Jr. Executive VIP

    Joined:
    Nov 23, 2008
    Messages:
    3,177
    Likes Received:
    1,563
    Occupation:
    Search Engine Marketing
    Location:
    The Internet
    • Thanks Thanks x 1
    Last edited: Jul 24, 2009
  18. joesomebody

    joesomebody Registered Member

    Joined:
    Jan 31, 2008
    Messages:
    78
    Likes Received:
    19
    Home Page:
    Just write a little php script.
     
  19. crisis23

    crisis23 BANNED BANNED

    Joined:
    Jan 6, 2009
    Messages:
    253
    Likes Received:
    79
    Thanks to BozoClown

    problem solve +1 REP to u. very helpful :)