SOLVED
Concatenate 2 fields with a breakline and produce a CSV output file
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
msantoso
8 - Asteroid
‎11-02-2018
02:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
3 REPLIES 3
kat
12 - Quasar
‎11-02-2018
02:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ACE Emeritus
‎11-02-2018
03:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
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
‎11-02-2018
05:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
