Python parse CSV ignoring comma with double-quotes

csv, python, python-2.7

Solution

This should do:

lines = '''"AAA", "BBB", "Test, Test", "CCC"
           "111", "222, 333", "XXX", "YYY, ZZZ"'''.splitlines()
for l in  csv.reader(lines, quotechar='"', delimiter=',',
                     quoting=csv.QUOTE_ALL, skipinitialspace=True):
    print l
>>> ['AAA', 'BBB', 'Test, Test', 'CCC']
>>> ['111', '222, 333', 'XXX', 'YYY, ZZZ']

Problem

I have a CSV file with lines like this: ``` "AAA", "BBB", "Test, Test", "CCC" "111", "222, 333", "XXX", "YYY, ZZZ" ``` and so on ... I dont want to parse comma's under double-quotes. ie. My expected result should be ``` AAA BBB Test, Test CCC ``` My code: ``` import csv with open('values.csv', 'rb') as f: reader = csv.reader(f) for row in reader: print row ``` I tried using csv package under python but no luck. The parses explodes all comma's. Please let me know if I'm missing something

Original source