Embedded Text Qualifiers in CSV FilesI 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.
Sr. Business Intelligence Developer, Data Platform & Analytics
Posted Tue Sep 22 2015 9:39am by IFBI_Clicky_Read