customize the tFileOutputDelimited filename

[Anonymous]

hello there,
im using tFileOutputDelimited for extracting data from advantage database, and i turn the "split output in several files and fill the "Rows in each output file" with 50 rows per file. and it succeed generating several file which is contains 50 records per file.
i fill the File name attribute at the Basic Settings with "TestFile.txt" and talend add extra number on each file so my file become "TestFile0.txt", "TestFile1.txt" and so on. (im not using outputstream)
the problem is, i want to format the file name into "File-XX-YYYYMMDD.txt", which XX is the extra number so my file would be "File-01-20130101.txt", "File-02-20130101.txt", "File-03-20130101.txt" and so on.
so is it posible to do it? cause i have searching through google and found nothing
thanks
Regards

[Anonymous]

Hi setiawand,
I have had this kind of requirement. Go through the screenshots..
This would be helpful I guess.

[Anonymous]

thanks for the solution but i see that the split index reside at the end of the filename, can it be placed after the "File" so it could be like this "File_01_20130101.txt", "File_02_20130101.txt", etc
thanks

[Anonymous]

thanks for the solution but i see that the split index reside at the end of the filename, can it be placed after the "File" so it could be like this "File_01_20130101.txt", "File_02_20130101.txt", etc
thanks

Hi, Split index was not given in job. By default TOS appends this index to each file when it finds same name of the files. It appends at the end of the file. We can append this in the middle of file name with the help of global parameters I guess.