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

break up a csv file or xls file

Discussion in 'General Programming Chat' started by vistaland, Jul 7, 2008.

  1. vistaland

    vistaland Registered Member

    Joined:
    Mar 1, 2008
    Messages:
    61
    Likes Received:
    114
    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
     
  2. jaeden

    jaeden BANNED BANNED

    Joined:
    Jun 3, 2008
    Messages:
    232
    Likes Received:
    28
    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
     
  3. Caveman

    Caveman Newbie

    Joined:
    Jan 23, 2008
    Messages:
    28
    Likes Received:
    21
    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
     
  4. vistaland

    vistaland Registered Member

    Joined:
    Mar 1, 2008
    Messages:
    61
    Likes Received:
    114
    thanks guys great help
     
  5. ciaozz

    ciaozz Junior Member

    Joined:
    Apr 17, 2008
    Messages:
    130
    Likes Received:
    27
    pls anyone have working download link for this file..? CSV_Splitter.rar
     
  6. corbin2

    corbin2 Registered Member

    Joined:
    Jan 16, 2010
    Messages:
    66
    Likes Received:
    41
    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.