Concatenate 2 fields with a breakline and produce a CSV output file

[msantoso]

dear All,

I need to concatenate the two address fields into one field and insert a breakline 

[Address]+"

"+[Address2]

this works fine but when I produce the csv file, the second line is lost.

and a CSV file is what I need to deliver.

could you please help me? 

thank you 

myriam

[kat · Accepted solution]

Hi @msantoso

A field in a csv can only have a line break if it's surrounded by double quotes (see here). These would have to show up in your final csv though.

To get this right you'll have to use:

'"'+

[Address]+'

'+[Address2]+'"'

That's a double quote wrapped in single quotes.

Hope this helps.

Kat

[BenMoss]

I cannot replicate the issue you have but as Kat mentions, your text must be surrounded by quotes in order for this to work.

However, I would produce those quotes in a different way to Kat. In the output data tool, providing you have the 'use quotes to delimit fields' to auto it should do this for you, or you can use always.

Ben

[msantoso]

Hi Kat, 

It took me a while to check that the output file is correctly uploaded and that the address field displays correctly, and it works !!!! 

thank you very much for your help.

best regards,

myriam