Inserting multiline text in a csv field

text csv multiline export-to-csv
Tabrez Ahmed picture Tabrez Ahmed · May 11, 2012 · Viewed 23.6k times · Source

I want to insert a multiline text data in a CSV field.

Ex:

var data = "\nanything\nin\nthis\nfield";
var fields = "\"Datafield1\",\"Datafield2:"+data+"\"\n";

When I save fields into a csv file and open it using MS Excel, I get to see only the first column. But when I open the file using a text editor I see:

"Datafield1","Datafield2:
anything
in
this
field"

I don't know whether I am going against CSV standards. Even if I am going against Please help me with a workaround.

Thanks...

Answer

Grzegorz Grzybek picture Grzegorz Grzybek · May 11, 2012

By default MS Excel uses semicolon as a separator. use ; and you'll see this:

enter image description here

Related questions

How can I read and parse CSV files in C++?

I need to load and use CSV file data in C++. At this point it can really just be a comma-delimited parser (ie don't worry about escaping new lines and commas). The main need is a line-by-line parser that will …

Read More
I need to write VBS WScript.Echo output to text or cvs

I am attempting to write a VBScript that will list all of the installed application on a system in a text file or csv. I was able to find an existing code to list all of the software (including name, …

Read More
Writing to a text file error - Must be str, not list

I have been having problems with some code I am writing. Basically, when I run the code I enter an 8 digit number and it should scan the CSV file to see if the number is inside the file. If it …

Read More