topic [resolved] Preserve Carriage Returns From SQL Column Input in Talend Studio

[resolved] Preserve Carriage Returns From SQL Column Input

_AnonymousUser — Fri, 06 Jan 2017 10:16:25 GMT

I have a SQL column (memo field) which contains carriage returns. How can I preserve the carriage returns in my Excel file output throigh tMap ?
Example :
Input :
TEXT LINE 1
TEXT LINE 2
Should output to
TEXT LINE 1\n TEXT LINE 2\n
How do I make sure code checks for each available carriage return, so it doesn't stop on line 1 ?

Re: [resolved] Preserve Carriage Returns From SQL Column Input

Anonymous — Tue, 17 Jan 2017 10:00:59 GMT

Hi,
Do you want to get full row from your output?
Best regards
Sabrina

Re: [resolved] Preserve Carriage Returns From SQL Column Input

_AnonymousUser — Tue, 17 Jan 2017 20:24:06 GMT

Hi,

I solved this by adapting the input query.

Replace (CONVERT(VARCHAR(MAX), dbo.TABLE.COLUMN_NAME) , CHAR(10), '\\n') AS COLUMN_NAME_CLEAN

Re: [resolved] Preserve Carriage Returns From SQL Column Input

Anonymous — Wed, 18 Jan 2017 08:46:14 GMT

Hi,

eplace (CONVERT(VARCHAR(MAX), dbo.TABLE.COLUMN_NAME) , CHAR(10), '\\n') AS COLUMN_NAME_CLEAN

Great that you have fixed this issue by yourself. Thanks for your prompt reply and sharing your solution with us.
Best regards
Sabrina