csv file enclosed with double quotes not stripping quotes
Posted
by sjw
on Stack Overflow
See other posts from Stack Overflow
or by sjw
Published on 2010-04-30T04:39:11Z
Indexed on
2010/04/30
4:47 UTC
Read the original article
Hit count: 420
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?
© Stack Overflow or respective owner