Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with Row Separator in tFileOutputDelimited

I'm using Talend 3.1.3.
I was following this bug but it has been closed: 0010065: escape sequence "\n" not recognise by Notepad into the text file generated by tFileOutputDelimited
I'm not sure how the bug reporting process works, but I am still seeing a problem. When I look at a "normal" .txt file in a hex editor, I see hex 0D0A at the end of each line. I tried several options in the Row Separator in tFileOutputDelimited:
\n results in hex 0A
\r\n results in hex 0D
\n\r results in hex 0A
It seems to be putting the first char (0D or 0A) but not both in the resulting file. How can I get hex 0D0A as the row separator? Is there a hex format I can use in the field? The bug stated to use another editor, but my customer uses Notepad.
Thanks.
UPDATE: Funny thing happened...I actually wanted to email the file after creation, so I added a tSendMail and attached the created file. Even though the original file stored on disk does not format correctly (contains only hex 0D), the file is fine after it is emailed to a destination (0D0A appears at the end of each line and it displays fine). So, if anyone else is having this problem, just email it after creation and it will get fixed.
Labels (2)
5 Replies
cmills
Contributor
Contributor

I know this is an OLD message, but you can get the result he desired with: "\r"+"\n" as the Row Separator.
Anonymous
Not applicable
Author

Thanks.
It worked fine for me!!
Alex31
Contributor
Contributor

For me too, thank you cmills.
Anonymous
Not applicable
Author

Hi, 

I have a similar problem with processing a UTF-8 file that I need to switch to UTF-16. Talend returns me a separator that gives in hexa 00 0D 0A. as if the conversion wasn't good. I tried the solution given above but it doesn't work in my case. I'm on Talend DI 6.3.1, if someone has a solution I'm a taker.

Thx 0683p000009MACn.png

TRF
Champion II
Champion II

Open a new case