Information about carriage return within concatenate in Sagent

Product Feature: Design Studio

 
Scenario:
Sagent user need to transfer data from their old operational system to a new system. One of the challenges is that the user have to concatenate 3 columns into 1 large column, but there needs to be a CARRIAGE RETURN between the columns in the Concatenation transform (or Expression Calculator) so that the result shows each element on a new line within the text-box of their new system.
For example:
[text1]
[text2]
[text3]
rather than: [text1] [text2] [text3] 

Solution:
Test with the data by using the Concatenation transform to concatenate 3 columns and include the CHAR(13) and CHAR(10) (carriage return and Line Feed) in between. It should work, since this is what SQL Server expects it and will store it as such.
For example, the Concatenation transform should do this:
Col1 +CHAR(13)+CHAR(10)+ Col2 +CHAR(13)+CHAR(10)+ Col3
to create the one new column "MyNewCol".

Then SQL Server table will contain the Carriage Return and Line Feed as part of MyNewCol. The receiving application that must display MyNewCol should expect the CHAR(10) and CHAR(13).
UPDATED:  December 4, 2017