Splitting converted txt file from a csv file with 2 million rows

[anthonyjr (Anthony)]

I have a csv file with 2 million rows of transaction and I convert it to text file.

Is there a way I can split the converted text file into 1 million transaction rows or an N value of transaction rows?

[jack.chan]

1. use read text file to read text file to string variable e.g. txt
2. assign transactionData = System.Text.RegularExpressions.Regex.Split(txt, environment.NewLine)
   where transactionData = array of string

transactionData will become the N value of transaction rows

[anthonyjr (Anthony)]

Sorry, where is the splitting part?

[jack.chan]

@jack.chan

assign transactionData = System.Text.RegularExpressions.Regex.Split(txt, environment.NewLine)
where transactionData = array of string

this is the splitting part

[anthonyjr (Anthony)]

I mean the converted text file has 2 million transaction rows and I want to split it into 2 or N files.

so if it is 2 splits, the expected output is 2 files with 1 million transaction rows each file.

[jack.chan]

use this
test11.xaml (10.7 KB)
example:

set split count here

result