How to export CSV with multiine text data

[Pratap Pundir]

I have a CSV file in which some of the columns contain multiline text data. See below. Sample file attached.

To import it safely, I have to use bindquotes

 
 import delimited using "output-16350782302.csv", bindquote(strict) maxquotedrows(10000)

After running my analyses, I want to save the data frame into a new csv (let's say output.csv) Unfortunately, the export doesn't work as expected - the multi-line description_story (and description_risk) gets broken up...`export delimited` command does not have a bindquote(strict) option... Any suggestions on how to safely export this multiline text data?

[Leonardo Guizzetti]

Have you tried the -quote- option? I haven't tried this myself but it seems reasonable.

[Pratap Pundir]

What -quote- option? I couldn't find anything in the manual about it...

[Leonardo Guizzetti]

See -help export delimited- then read down till you see the -quote- option for export options. It claims to always wrap strings in quotes, which might provide sufficient structure for you to export your data as a CSV file.