linux删除csv空格符号,删除csv fi中的换行符

您可以搜索后面跟不以“@”开头的行，例如\r?\n+(?!@\d+;)。在

以下是从regex101demo生成的。它用一个空格来代替这些行尾。你可以把它改成你喜欢的任何东西。在# coding=utf8

# the above tag defines encoding for this document and is for Python 2.x compatibility

import re

regex = r"\r?\n+(?!@\d+;)"

test_str = ("@4627289301; Lima, Peru; 490; 835551022915420161; Sat Feb 25 18:04:22 +0000 2017; \"\"[OJO!\n"

"la premiacin de los #Oscar, nuestros amigos de @cinencuentro revisan las categoras.\n"

"+info: co/plHcfSIfn8]\"\"; 0\n"

"@624974422; None; 114; 835551038581137416; Sat Feb 25 18:04:26 +0000 2017; \"\"[Porque nunca dejamos de amar]\"\"; 0")

subst = " "

# You can manually specify the number of replacements by changing the 4th argument

result = re.sub(regex, subst, test_str, 0, re.MULTILINE)

if result:

print (result)

# Note: for Python 2.7 compatibility, use ur"" to prefix the regex and u"" to prefix the test string and substitution.