Archived Forum Post

Index of archived forum posts


CSV file with single double-quote

Jun 19 '12 at 09:11

I have a CSV file, the fields are delimited with commas and double quotes, but sometimes a field will have a single double quote. How do I get the chilkat CSV function to read this in correctly?

The sample I have is


"ABC123","4","40" HD TV"

I have tried escaping the single double quote but this has not helped. How can I import this as I want?


A double-quote that occurs within a double-quoted string should be represented as a pair of double quotes, like this:

"ABC123","4","40 ""HD TV"


For more information about CSV standards, see