Is there a easy way to split a large CSV file with multiline entries?

Question

Hi i have this huge 14Gb CSV file with entries that span multiple lines and would like a easy way to split it, BTW the split command will not work cause it is not aware of how many columns there are on a row and will cut it wrong.

Answer 1

Using XSV (https://github.com/BurntSushi/xsv) is very simple:

xsv split -s 10000 ./outputdir inputFile.csv

-s 10000 to set the number of records to write into each chunk.