20

If I want to split a list of words separated by a delimiter character, I can use

>>> 'abc,foo,bar'.split(',')
['abc', 'foo', 'bar']

But how to easily and quickly do the same thing if I also want to handle quoted-strings which can contain the delimiter character ?

In: 'abc,"a string, with a comma","another, one"'
Out: ['abc', 'a string, with a comma', 'another, one']

Related question: How can i parse a comma delimited string into a list (caveat)?

Community
  • 1
  • 1
math
  • 2,775
  • 3
  • 22
  • 28

2 Answers2

42
import csv

input = ['abc,"a string, with a comma","another, one"']
parser = csv.reader(input)

for fields in parser:
  for i,f in enumerate(fields):
    print i,f    # in Python 3 and up, print is a function; use: print(i,f)

Result:

0 abc
1 a string, with a comma
2 another, one
Tomalak
  • 322,446
  • 66
  • 504
  • 612
8

The CSV module should be able to do that for you

Greg
  • 307,243
  • 53
  • 363
  • 328