How to read smart quotes using csvreader?

[vivekcpatel]

Hi,

I want to use CSV Reader to read a csv file that can read foreign characters ("iso-8859-1") and also smart quotes (http://practicaltypography.com/straight-and-curly-quotes.html).

For example the file looks something like this with header.

Column 1,Column 2,Column 3 """This"" is ""My"" test ""Title""",Screenplay 'by' 'Will',"""This"" is ""My"" test ""Title"" notes notes notes" “This” is my “Second” test “Title”,Second ‘Screenplay’ by ‘Will’,“This” is my “Second” test “Title”

Smart Quotes.pdf

Thanks, Vivek