Splitting a 1500 row CSV into Equal Parts

We have an input file of 1500 rows, we split this down into 300 row parts so 5 in total.

This is OK when its 1500 rows

If I have any less than this I will only get the division of 300 ie

1300 Row input file, I will get 4 files and then no fifth file with the remaining 100 rows.

I know why I get this, because Im cycling through and have an if condition to check I have 300.

Any recommendations on how to solve my issue?

Hi,

The following sample will help you. (Please use ReadCSV and WriteCSV instead of ReadRange and WriteRange)

Regards,

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.