ElectroMan
Regular Member
- Dec 13, 2009
- 254
- 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!
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!