break up a csv file or xls file

V

vistaland

Registered Member

Mar 1, 2008

61

118

• Jul 7, 2008

• #1

Does anyone know how to break up a large csv file or xls file 100,000 records into individual files of 500 records each?

Yea i know copy and paste... Im looking for a macro or script or some kind software to save me time i have to do this on a few files.

Thanks in advance

 

jaeden

BANNED

Jun 3, 2008

232

28

• Jul 7, 2008

• #2

if nobody replies with a script for this within the next 2 hours message me and ill write it for you. im just a little busy atm

 

C

Caveman

Newbie

Jan 23, 2008

28

21

• Jul 7, 2008

• #3

Here is CSV Splitter, including the source code so you can modify it to fit your needs

Code:

http://rapidshare.com/files/110848750/CSV_Splitter.rar

 

V

vistaland

Registered Member

Mar 1, 2008

61

118

• Jul 7, 2008
• Thread Starter Thread Starter

• #4

thanks guys great help

 

ciaozz

Junior Member

Apr 17, 2008

153

33

• Feb 4, 2010

• #5

pls anyone have working download link for this file..? CSV_Splitter.rar

 

C

corbin2

Registered Member

Jan 16, 2010

66

42

• Feb 4, 2010

• #6

I was looking for a tool like this as well and found this one. I think it's the same:

Code:

hxxp://www.fxfisherman.com/forums/forex-metatrader/tools-utilities/75-csv-splitter-divide-large-csv-files.html#post727

Didn't try it yet tho.