我已经从数据库导出了CSV文件。某些字段是较长的文本块,可以包含换行符。从这个文件中只删除双引号中的换行符,而保留所有其他行的最简单方法是什么?
我不关心它是否使用Bash命令行、一行程序或简单的脚本,只要它能工作即可。
例如,
"Value1", "Value2", "This is a longer piece
of text with
newlines in it.", "Value3"
"Value4", "Value5", "Another value", "value6"
应该删除较长文本中的换行符,但不能删除分隔两行的换行符。
发布于 2011-11-22 06:43:33
在Python中:
import csv
with open("input.csv", "rb") as input, open("output.csv", "wb") as output:
w = csv.writer(output)
for record in csv.reader(input):
w.writerow(tuple(s.remove("\n") for s in record))
发布于 2011-11-22 06:43:13
这里有一个Python的解决方案:
import re
pattern = re.compile(r'".*?"', re.DOTALL)
print pattern.sub(lambda x: x.group().replace('\n', ''), text)
在线查看它的工作方式:ideone
发布于 2011-11-22 07:40:53
这是非常简单的,但可能对您有效:
# cat <<\! | sed ':a;/"$/{P;D};N;s/\n//g;ba'
> "Value1", "Value2", "This is a longer piece
> of text with
> newlines in it.", "Value3"
> "Value4", "Value5", "Another value", "value6"
> !
"Value1", "Value2", "This is a longer piece of text with newlines in it.", "Value3"
"Value4", "Value5", "Another value", "value6"
https://stackoverflow.com/questions/8219502
复制相似问题