[resolved] Preserve Carriage Returns From SQL Column Input

[_AnonymousUser]

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 ?

[Anonymous]

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

[_AnonymousUser · Accepted solution]

Hi,

I solved this by adapting the input query.

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

[Anonymous]

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