Max csv rows reached, write two csv files

[byuli]

Hello,
I have a text file with over 2million rows that I need to convert to csv. When opened in Excel, it cannot hold more than around 1 million rows so users always get a warning saying that not the whole file downloaded.

I read a text file to string, Generate data table off the back of that string, and then I need to write the data table to a csv file.
How can I specify in Uipath to write a separate csv for every 1million rows in a data table please?

Many thanks for your help,
byuli

[Anthony_Humphries]

Adapt this workflow to your process. It reads a CSV line by line and appends the data to separate files. The arguments default to files in the current directory and is set for 25 lines per file, but these values are configurable.

Processusvierge.zip (10,6 Ko)

[byuli]

Thank you, works very well!