Inserting "New Line" between join (+) of 2 source tmap source columns to 1 destination column

[Tim_D_Baker]

My source MSSQL database has AddressLine1 and AddressLine2. Destination in Salesforce (Non Profit Support Pack) has single Address column but can display as 2 lines.

Expression in tmap for "BillingStreet" is: Contact.ADDRESSLINE1 + "WHAT GOES HERE" + Contact.ADDRESSLINE2

I've tried "\n" and "\\n" and "CHAR(10)" - but didn't work.

", " and " " works but not what I need

[Tim_D_Baker · Accepted solution]

I found my own answer

Contact.ADDRESSLINE1 + Character.toString ((char) 10) + Contact.ADDRESSLINE2

The character numbers are:

Char(10) – New Line / Line Break

Char(13) – Carriage Return

Char(9) – Tab