Inserting a carriage return?

One Star

Inserting a carriage return?

Hi 
I am trying to consolidate mailing address fields and I would like to be able to concatenate Mailing Line 1 and Mailing Line 2 but with a carriage return as the separator. Does anyone know if this is possible?  I could not find a way to do it and worked around it by exporting to excel but I love the Prep Tool and would love to be able to do all my manipulations within the tool. 
Thanks! 
Community Manager

Re: Inserting a carriage return?

Hello 
It is impossible to do it so far.
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business