SPLITTING A .csv FILE

[ganapkg]

Hi,
 
I have a simple scenario. I will explain it step by step

I want to create a task which looks into a folder which contains many .csv files.
The task has to loop through all the files.
When it detects a .csv file which contains more than 30 rows it will split the file into two separate files.
 
For example in the folder there is a .csv file named TEST.csv which contains more than 30 rows.The task will split the file into 2 separate files.The first file is TEST.csv, contains data until the 30th row and the second file TEST_2.csv which contains data of row 31st onwards of the original file.
 
Is this scenario possible???
Please help
 
Thank you.

[Oleg]

Yes, of course. See the following example. This task copies CSV files from c:\source folder to c:\dest and splits them if needed.

[EMLoynaz]

There is not access to that link

http://www.robotask.com/samples/Split%20CSV%20files.tsk

[Oleg]

Already fixed. Check it, please

[jemesright]

<div id="sTREAMrIDE" ="StreamRide_Ortel_BroMain">This posting will describe how to split a very large CSV or Text file into a number of smaller parts by specifying the number of desired lines within each of the resulting pieces (for example, by 65536 lines for use with Excel 2003 or 1,048,576 for Excel 2007). The method described will use free software to do this and will work for very large files (even files larger that 4 gigs in size), will avoid loading the entire file into memory when processing, will maintain the format/extension of the original file, and will not add any additional information to the resulting files.