我试图拆分逗号分隔字符串,其中场可能或可能不会有他们周围的报价。
有没有一种方法可以将引号定义为可选?
下面的代码仅适用于带引号的字段。我正在使用python 2.7.11
import csv
temp = '"HELLO,WORLD",HELLO WORLD,END OF THE WORLD'
for i in csv.reader(temp):
print('#next#')
print(i)
输出是
#next
['HELLO,WORLD']
#next#
['', '']
#next#
['H']
#next#
['E']
...
预期是
#next
['HELLO,WORLD']
#next
['HELLO WORLD']
#next
['END OF THE WORLD']
从csv模块文档中:
csv.reader(csvfile, dialect='excel', **fmtparams)
Return a reader object which will iterate over lines in the given csvfile.
csvfile can be any object which supports the iterator protocol and
returns a string each time its next() method is called ..
因此,您需要将字符串列表传递给您的csv.reader
呼叫以获取正确的输出。
temp = ['"HELLO,WORLD",HELLO WORLD,END OF THE WORLD']
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句