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 -

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
[email protected]

Posted Tue Sep 22 2015 9:39a by IFBI_Clicky***

You must be logged in to your account to post!