topic Re: customize the tFileOutputDelimited filename in Talend Studio

customize the tFileOutputDelimited filename

Anonymous — Thu, 28 Mar 2013 08:58:00 GMT

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

Re: customize the tFileOutputDelimited filename

Anonymous — Thu, 28 Mar 2013 09:12:28 GMT

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

Re: customize the tFileOutputDelimited filename

Anonymous — Thu, 28 Mar 2013 09:23:53 GMT

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

Re: customize the tFileOutputDelimited filename

Anonymous — Thu, 28 Mar 2013 11:17:53 GMT

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.

Re: customize the tFileOutputDelimited filename

Anonymous — Tue, 09 Jun 2015 07:59:10 GMT