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

AddressesWithBreakLine.csv

Preparation

Accepted answers

kat

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

All comments

kat

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703