topic Re: tab separator in tFileoutputDelimited and tFileoutputExcel in Talend Studio

tab separator in tFileoutputDelimited and tFileoutputExcel

Anonymous — Sat, 16 Nov 2024 14:33:25 GMT

hello
what character should be used in a regular tFileoutputDelimited in order to get tab separator at the end ?
is it possible to write in the same tFileoutputExcel excel file with different steps ? anyway to write in different sheets of this tFileoutputExcel along the job ? the idea would be to export in the same file in different sheets several dataset
David

Re: tab separator in tFileoutputDelimited and tFileoutputExcel

Anonymous — Thu, 06 Sep 2007 20:24:39 GMT

Hello

what character should be used in a regular tFileoutputDelimited in order to get tab separator at the end ?

"\t"

is it possible to write in the same tFileoutputExcel excel file with different steps ? anyway to write in different sheets of this tFileoutputExcel along the job ? the idea would be to export in the same file in different sheets several dataset

I'm sorry to say that this option is not available, neither in Perl components, neither in Java components.
Regards,
Michaël.

Re: tab separator in tFileoutputDelimited and tFileoutputExcel

Anonymous — Fri, 07 Sep 2007 11:26:13 GMT

many thanks for this answer

Re: tab separator in tFileoutputDelimited and tFileoutputExcel

Anonymous — Wed, 09 Oct 2013 23:17:33 GMT

Hi,
Could any please let me know how i can name it with data for output file using tfileoutputdelimited? I have to output the file as "FileNameMMDDYYYY.txt" each day. File name should that day data in place of MMDDYYY.
Thanks,

Re: tab separator in tFileoutputDelimited and tFileoutputExcel

Anonymous — Thu, 10 Oct 2013 09:15:35 GMT

Hi srk08536,
You'd better open a new topic for your requirement, which provide other community user with a chance to give a response.
For you scenario, here is related forum https://community.talend.com/t5/Design-and-Development/customize-the-tFileOutputDelimited-filename/td-p/102649, hope it will be useful for your case.
Best regards
Sabrina

Re: tab separator in tFileoutputDelimited and tFileoutputExcel

Anonymous — Tue, 15 Oct 2013 16:08:35 GMT

Hi Sabrina,
Thanks for your reply. I am not able to find the option to create new topic. That's why I posted my questions on the existing topics.

Re: tab separator in tFileoutputDelimited and tFileoutputExcel

Anonymous — Tue, 15 Oct 2013 16:14:35 GMT

use below code in file name text box.

"FileName"+TalendDate.getDate("MMddyyyy")+".txt"

Re: tab separator in tFileoutputDelimited and tFileoutputExcel

Anonymous — Wed, 16 Oct 2013 04:16:49 GMT

Hi srk08536,
From forum home page, select related section and get into it. You will find link "Post a new topic" by which you can create new topic with your subject. Let me know if it is OK with you.
Best regards
Sabrina