DSXchange

Input : Oracle
Output : Oracle

I have 5 input structured address fields (Block-House-No, Street Name, Building Name, Floor No, Unit No). These fields are to be concatenated into a single output address field but with multiple lines : (Line 1 : Block-house-no, Floor No and Unit NO; [linefeed] line 2 with Street Name [linefeed] and line 3 with Building Name)

How do I create the 'carriage return' (linefeed) for the output field ?

Thank you

Use char(10) in a transformer. Eg. input.col1 : char(10) : input.col2

Hi,
Just wanted to point out that Vincent only mentioned the Line Feed part, If you need to plant CRLF the use Char(13) : Char(10)
Unix line termination is LF and windows is CRLF, so if it's to be displayed in a PC client while read from the Oracle DB you need to imbed CRLF.

IHTH,