[issue36246] csv.writer lineterminator affects csv escaping
flow2k added the comment: Okay, thanks for pointing to the doc. I did not expect the line termination to affect escaping, but I can see why these may be related. Per your comment, I've added quoting=csv.QUOTE_NONNUMERIC. Instead of Excel, I am using Gdocs, and this escaping enables Gsheets to ingest it. Closing the issue... -- stage: -> resolved status: pending -> closed ___ Python tracker <https://bugs.python.org/issue36246> ___ ___ Python-bugs-list mailing list Unsubscribe: https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
[issue36246] csv.writer lineterminator affects csv escaping
New submission from flow2k : output = io.StringIO() csvData = [1, 2, 'a', 'He said "what do you mean?"', "Whoa!\rNewlines!"] writer = csv.writer(output,lineterminator='\n') writer.writerow(csvData) print(repr(output.getvalue())) #does not escape \r as expected -- messages: 337537 nosy: flow2k priority: normal severity: normal status: open title: csv.writer lineterminator affects csv escaping type: behavior versions: Python 3.7 ___ Python tracker <https://bugs.python.org/issue36246> ___ ___ Python-bugs-list mailing list Unsubscribe: https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com