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

Tim_D_Baker — Sat, 16 Nov 2024 00:20:25 GMT

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

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

Tim_D_Baker — Wed, 31 Mar 2021 02:03:57 GMT

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

topic Re: Inserting "New Line" between join (+) of 2 source tmap source columns to 1 destination column in Talend Studio

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

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