Export CSV (a lot of extra symbols)
imGua
Member Posts: 1,089
When I export CSV with a simple text made in GS . I got a lot of symbols that shouldn't be there. What am I doing wrong? http://gyazo.com/f2fc671cfc3ec3d1a7e899af122de1f0
Comments
That's an odd problem. Can you tell us more about how you're making this happen? Got an example project you can share?
http://game-views.net/xlam/!TextTest.zip
Shadows Peak is an atmospheric psychological horror that explores the dark side of a player.
Looking into this now.
Okay, so the problem seems to be that you're using commas in data that's being exported into CSV. This causes the code to escape your hand-entered commas with backslash. It looks like this code is also escaping other letters too.
Looking into the code shows me that it's XML-escaping your exported data. That means that any characters not supported in an XML file are escaped according to the XML standard-ish. So "&" becomes "& amp;" I say "ish" because we also escape commas, newlines, tabs and line feeds.
You can read more about XML escaping here: http://stackoverflow.com/questions/1091945/where-can-i-get-a-list-of-the-xml-document-escape-characters
So, I'm not sure that this is the best way to handle CSV export. I'll bounce stuff off the team and find out if there's a good reason we do it this way. I'm open to any suggestions here too.