6
1
I am experiencing a weird unknown behavior in excel. The sheet I want to export to a csv file consists of 4 columns with data like this:
site.aspx|de|lblChanges.Text|some text that will be used somewhere
Now what happens is, if the last column containg the text has doublequotes in it, Excel adds another double quote to it for every double quote already in it.
Example:
site.aspx|de|lblChanges.Text|some text that will used somewhere <a href="/clickety.aspx">here</a>
Gets transformed into
site.aspx|de|lblChanges.Text|"some text that will used somewhere <a href="/clickety.aspx">here</a>"
Notice the extra doublequotes at the beginning and the end, which clearly should not be there. this data gets inserted in a database and used as text resources for globalization. If I render a literal control with those extra double quotes the functionality breaks.
How can I supress this behavior in Excel?
Which columns do you wish to export?? – Gary's Student – 2015-01-20T14:18:46.250
All of them, I just care about the double quote issue. – Marco – 2015-01-20T14:21:26.573