Last post Oct 03, 2011 03:15 PM by Lannie
Oct 03, 2011 01:53 AM|saurabh jain|LINK
I have a csv file that contain about 1 Crore rows.
I need to break this file into 10 csv files those all need to be contain around 10 lakh records.
Oct 03, 2011 03:15 PM|Lannie|LINK
You can use SYSTEM.IO FILE STREAMING
to read each line to the end of the line delimiter (most files it is Carriage Return Line Feed)
and write out that line to a file,
looping every 10 lakh records to start a new file.
It is very fast in C# or VB.NET, even for 1 Crore rows.