How to split CSV files as per number of rows specified?

by

Use the Linux split command:

split -l 20 file.txt new

Split the file “file.txt” into files beginning with the name “new” each containing 20 lines of text each.

Type man split at the Unix prompt for more information. However you will have to first remove the header from file.txt (using the tail command, for example) and then add it back on to each of the split files.

More Related Contents:

  1. Split one file into multiple files based on delimiter
  2. Sorting a tab delimited file
  3. find a word from all files excluding 1 directory
  4. When did Access control list (ACL) come to Unix/Linux?
  5. Looping through the content of a file in Bash
  6. How do SO_REUSEADDR and SO_REUSEPORT differ?
  7. Save modifications in place with awk
  8. Why should eval be avoided in Bash, and what should I use instead?
  9. Setting an argument with bash [duplicate]
  10. How to kill a child process after a given timeout in Bash?
  11. Environment variable substitution in sed
  12. What does “&” at the end of a linux command mean?
  13. Delete empty lines using sed
  14. Linux: copy and create destination dir if it does not exist
  15. Getting a unique id from a unix-like system
  16. How to sort a file in-place?
  17. How to get full path of a file?
  18. How do I syntax check a Bash script without running it?
  19. Is it OK to use the same input file as output of a piped command?
  20. How to get the command line args passed to a running process on unix/linux systems?
  21. Relinking an anonymous (unlinked but open) file
  22. When to wrap quotes around a shell variable?
  23. How do you normalize a file path in Bash?
  24. Comparing Unix/Linux IPC
  25. Is there a way to make mv create the directory to be moved to if it doesn’t exist?
  26. Rename all files in a folder with a prefix in a single command
  27. Need to remove the count from the output when using “uniq -c” command
  28. Creating temporary files in bash
  29. How do you run a script on login in *nix?
  30. What is the difference between source and export?

Leave a Comment