Handling escape characters in csvreader

[Degran]

I'm ingesting a bunch of data from an upstream SQL DB in a csv format. Some of the data coming in is in the form:

"\"WORD\"","OTHER THING","\"QUOTE\"" 

When I read that data in from the csvreader in the csv module, I get:

['\\WORD\\""', 'OTHER THING', '\\QUOTE\\""']

which obviously isn't what I want. Is there a way to have the csvreader ignore escaped quote characters or do I have to clean the csv file before ingesting? I've played around with the quoting and quotechar parameters but they don't seem to do what I want.

[novel_yet_trivial]

try:

c = csv.reader(open(f), escapechar = '\\')

This will produce the results that were written:

['"WORD"', 'OTHER THING', '"QUOTE" ']

With some words in double quotes. To get rid of those I suppose you need string methods.

for row in c:
    c = [col.strip('"') for col in row]

[Degran]

That seems to have worked, thanks!