CODEWITHSUNDEEP
textcsvmultilineexport-to-csv
Tabrez Ahmed
Tabrez Ahmed

Reputation: 2950

Inserting multiline text in a csv field

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...

Upvotes: 22

Views: 44345

Answers (2)

Peabody
Peabody

Reputation: 71

Here I place some text followed by the NewLine char followed by some more text and the whole string MUST be quoted into a field in a csv file.

Do not use a CR since EXCEL will place it in the next cell.

""2" + NL + "DATE""

When you invoke EXCEL, you will see this. You may have to auto size the height to see the entire cell.

2

DATE

Here's the code in Basic

CHR$(34,"2", 10,"DATE", 34)

Upvotes: 4

Grzegorz Grzybek
Grzegorz Grzybek

Reputation: 6237

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

enter image description here

Upvotes: 10

Related Questions