How to split the .csv files in linux:

How to split the .csv files in linux:


 Below Split command split the files for every 10000000 rows.

example:

Syntax:-> $split -l <number_of_rows> <source_file_name.csv> <some_prefix>

Example

$>split -l 10000000 ssedba_11110.csv A

$>ls -rlt A*
-rw-r--r-- 1 oracle dba 158799986 Aug 16 19:19 Aaa
-rw-r--r-- 1 oracle dba 161393224 Aug 16 19:20 Aab
-rw-r--r-- 1 oracle dba 160001493 Aug 16 19:20 Aac
-rw-r--r-- 1 oracle dba 161152635 Aug 16 19:20 Aad
-rw-r--r-- 1 oracle dba 160599373 Aug 16 19:20 Aae
-rw-r--r-- 1 oracle dba 160278426 Aug 16 19:20 Aaf
-rw-r--r-- 1 oracle dba 160080772 Aug 16 19:20 Aag
-rw-r--r-- 1 oracle dba 157922087 Aug 16 19:20 Aah
-rw-r--r-- 1 oracle dba 153595696 Aug 16 19:20 Aai
-rw-r--r-- 1 oracle dba 204728027 Aug 16 19:20 Aaj
-rw-r--r-- 1 oracle dba 188900737 Aug 16 19:20 Aak
-rw-r--r-- 1 oracle dba 177680796 Aug 16 19:20 Aal
-rw-r--r-- 1 oracle dba 152519642 Aug 16 19:20 Aam
-rw-r--r-- 1 oracle dba  62699589 Aug 16 19:20 Aan