CODEWITHSUNDEEP
excelcsvquotes
sjw
sjw

Reputation: 2633

csv file enclosed with double quotes not stripping quotes

I am generating a csv download from my web server and to be safe, I have enclosed each field with double quotes.

i.e.

"Field1","Field2","Field3","Field4"
"row1_field1","row1_field2","row1_field3","row1_field4"
"row2_field1","row2_field2","row2_field3","row2_field4"

The problem is that when the file is opened in Excel, it does not strip all quotes... Therefore, some fields are appearing as: row1_field1 whereas others are appearing as "row1_field2"

What am I not doing to ensure that excel strips all surrounding quotes?

Upvotes: 1

Views: 1579

Answers (1)

Dean Harding
Dean Harding

Reputation: 72658

Make sure there are no spaces around the commas. So the following should work:

"row1_field1","row1_field2","row1_field3","row1_field4"
"row2_field1","row2_field2","row2_field3","row2_field4"

But this will show up with the quotes in place:

"row1_field1", "row1_field2", "row1_field3", "row1_field4"
"row2_field1", "row2_field2", "row2_field3", "row2_field4"

Upvotes: 5

Related Questions