Batch file to split .csv file

by

Try this out:

@echo off
setLocal EnableDelayedExpansion

set limit=20000
set file=export.csv
set lineCounter=1
set filenameCounter=1

set name=
set extension=
for %%a in (%file%) do (
    set "name=%%~na"
    set "extension=%%~xa"
)

for /f "tokens=*" %%a in (%file%) do (
    set splitFile=!name!-part!filenameCounter!!extension!
    if !lineCounter! gtr !limit! (
        set /a filenameCounter=!filenameCounter! + 1
        set lineCounter=1
        echo Created !splitFile!.
    )
    echo %%a>> !splitFile!

    set /a lineCounter=!lineCounter! + 1
)

As shown in the code above, it will split the original csv file into multiple csv file with a limit of 20 000 lines. All you have to do is to change the !file! and !limit! variable accordingly. Hope it helps.

More Related Contents:

  1. Windows batch script to parse CSV file and output a text file
  2. How do I make a log of all ECHO commands in a BATCH file?
  3. How do I minimize the command prompt from my bat file
  4. batch file Copy files with certain extensions from multiple directories into one directory
  5. Variables are not behaving as expected
  6. Single line with multiple commands using Windows batch file
  7. Where is “START” searching for executables?
  8. What does %~d0 mean in a Windows batch file?
  9. How to run a PowerShell script from a batch file
  10. How to code a BAT file to always run as admin mode?
  11. How can you zip or unzip from the script using ONLY Windows’ built-in capabilities?
  12. Run batch file as a Windows service
  13. windows batch SET inside IF not working
  14. How can I run a program from a batch file without leaving the console open after the program starts?
  15. How to check if a file exists from inside a batch file [duplicate]
  16. Batch files: List all files in a directory with relative paths
  17. Using parameters in batch files at Windows command line
  18. How to create an infinite loop in Windows batch file?
  19. Convert a small PS script into a long line in a .BATch file
  20. Kill a Process by Looking up the Port being used by it from a .BAT
  21. What is the easiest way to reset ERRORLEVEL to zero?
  22. Batch to remove duplicate rows from text file
  23. How to count no of lines in text file and store the value into a variable using batch script?
  24. How to test if a path is a file or directory in Windows batch file?
  25. Rename multiple files in cmd
  26. Split string with string as delimiter
  27. How to change Screen buffer size in Windows Command Prompt from batch script
  28. Delete all files and folders in a directory
  29. Using echo y as an automated response to a pcp hostkey prompt
  30. Changing a batch file when its running

Leave a Comment