该问题是由于文件的迭代是逐行完成的,而字符串的迭代是逐字符完成的。
你要StringIO http://docs.python.org/library/stringio/cStringIO http://docs.python.org/library/stringio#module-cStringIO(Python 2)或io.StringIO http://docs.python.org/library/io.html#io.StringIO(Python 3,感谢 John Machin 向我指出)因此字符串可以被视为类似文件的对象:
Python 2:
mystring = 'a,"b\nb",c\n1,2,3'
import cStringIO
csvio = cStringIO.StringIO(mystring)
mycsv = csv.reader(csvio)
Python 3:
mystring = 'a,"b\nb",c\n1,2,3'
import io
csvio = io.StringIO(mystring, newline="")
mycsv = csv.reader(csvio)
两者都将正确保留带引号的字段内的换行符:
>>> for row in mycsv: print(row)
...
['a', 'b\nb', 'c']
['1', '2', '3']