擅长:python、mysql、java
<p>您需要使用<a href="https://docs.python.org/3/library/stdtypes.html#str.replace" rel="nofollow noreferrer">^{<cd2>} method</a>手动将换行符替换为<code>\n</code>。</p>
<p>将<a href="https://docs.python.org/3/library/csv.html#csv.Dialect.lineterminator" rel="nofollow noreferrer">^{<cd3>}</a>选项设置为所需的字符序列。有关其他可用信息,请参见<a href="https://docs.python.org/3/library/csv.html#dialects-and-formatting-parameters" rel="nofollow noreferrer">the docs</a>。</p>
<pre><code>with open('csvfile.csv', 'w') as csvOutput:
writer = csv.writer(csvOutput, delimiter='|', escapechar=' ', quoting=csv.QUOTE_NONE, lineterminator='\n')
for row in data:
writer.writerow([s.replace('\n', '\\n').encode('utf-8') for s in row])
</code></pre>