Forums » Developers



Embedded Text Qualifiers in CSV Files

I encountered an issue where double quotes inside a CSV field were escaped by a backslash, resulting in a SQL Server Integration Services package not being able to read it.

Here's what it looks like:

"previous column",""quoted text escaped with backslash" more text","next column"

Am I wrong in thinking that the CSV standard calls for double quotes inside a field to be escaped by another double quote? Reference - http://tools.ietf.org/html/rfc4180

Here's what the same field would look like if escaped by double quotes:

"previous column","""quoted text escaped with double quotes"" more text","next column"

I tested this format successfully in SQL Server Integration Services.

Thank you,

Chris Koester
Sr. Business Intelligence Developer, Data Platform & Analytics
ckoester@allegient.com
linkedin.com/in/chriskoester

Posted Tue Sep 22 2015 9:39am by IFBI_Clicky_Read



Reply to this discussion

Forums are closed due to massive spam. Sorry.