--> [Help!] How to Handle Huge CSV files?

ElectroMan

Regular Member
Joined
Dec 13, 2009
Messages
254
Reaction score
772
Hey guys, I've got some huge csv files with about 250k rows. I need to simply take one column and copy/paste it into a text (notepad) file so I can load it for a bot.

Problem is that in excel my numbers in that column become 1Exxx because they are so large.

I tried open office but there is a limit of 65k rows. I split the files to be 50k rows each but it was taking forever to copy/paste each 50k file.

I even tried CSVed but I couldn't figure out how to export one column in the format that I need.

If I open the CSV file in notepad the column I need has "" quotations and I have a few million entries.

Help!
 
I'm not using it for this.

Hey sorry I dn't have the answer,
but just to tell you as a sidenote that if you use this excel file for FB friends, then you're losing a lot of friends in the process.
Let me explain. If you upload an excel file containing 10K emails on facebook, you'll get at most 250 to 500 friends at max, cause that appears to be the limit of friends facebook can handle at one time, whereas if you take the time to split them into files of 2K friends, you'll get up to 500 friends each time. Beyond that and you lose friends.
Of course this is based on the fact that you get 20 to 25% of your emails that are already on facebook, otherwise I'm not sure. I talk for my experience.

So again I don't have the answer to your question but that might help you if we are talking about the same thing.

Cheers
 
What you need is a CSV Splitter, a tool that divides large csv files into smaller ones.

I use this one: hxxp://www.fxfisherman.com/forums/forex-metatrader/tools-utilities/75-csv-splitter-divide-large-csv-files.html#post727
 
Back
Top