split CSV fields

[Peter Otten]

robert wrote:

> What is a most simple expression for splitting a CSV line with "-protected
> fields?
> 
> s='"123","a,b,\"c\"",5.640'

>>> import csv
>>> class mydialect(csv.excel):
...     escapechar = "\\"
...
>>> csv.reader(['"123","a,b,\\"c\\"",5.640'], dialect=mydialect).next()
['123', 'a,b,"c"', '5.640']

Peter