Hello everyone, I need help, as I have to manage the naming of output files in the split phase.

I have an input file named "file_import.csv" that I have to split into multiple files with a maximum of rows, and I need the split file names to contain the same name as the input file, the date,
which I can correctly to set from the properties of the "File output" and the total number of files in addition to the number of the split.

Example
file_import.csv 100 rows

I would need to split it into 5 rows of 20 lines

file_import_201903051550_$_TotFiles_1.csv

file_import_201903051550_5_1.csv
file_import_201903051550_5_2.csv
file_import_201903051550_5_3.csv
file_import_201903051550_5_4.csv
file_import_201903051550_5_5.csv

How can I recover and save the information of the total file ( $TotFiles )in a variable and then reuse it to complete the file name?


I use PDI Spoon 8.2 Community Ed

Thanks in advance to everyone.
Silvio