csv字段中包含有换行符 如何替换成其他字符

clonescopy

能把行末的回车换行'\r\n' 替换成其他字符么  比如^

clonescopy

bash-2.03$ echo `cat test.csv` > test2.csv
bash-2.03$ cat test2.csv
e,f,"c d ",222
bash-2.03$

只有第二行

clonescopy

bash-2.03$ echo `cat test.csv`
e,f,"c d ",222
bash-2.03$

还是不行

blackold

回复 30# clonescopy

在以下主机上测试通过(bash 3.0)：

$ uname -a
SunOS t1000 5.10 Generic_118833-33 sun4v sparc SUNW,Sun-Fire-T1000 Solaris

sed -e ':n' -e 'N;/'$'\r''/!b n' -e 's/\n//g' urfile

clonescopy

bash-2.03$ od -A d -t c test.csv
0000000   a   ,   b   ,   "   c  \n   d  \n   "   ,   1   1   1  \r  \n
0000016   e   ,   f   ,   "   c  \n   d  \n   "   ,   2   2   2  \r  \n
0000032
bash-2.03$ sed -e ':n' -e 'N;/'$'\r''/!b n' -e 's/\n//g' test.csv
a,b,"cd",111
e,f,"cd",222

clonescopy

echo -n `cat test.csv`
tr -s "[\r]" "[\n]" < test2.csv

clonescopy

谢谢 blackold (黑哥)

yinyuemi

awk:

awk '/"/{++p}{printf (p%2?$0"^"0"\n"}' file

qit4519

看不懂啊，我是菜鸟正学习中幽默笑话

clonescopy

awk:

awk '/"/{++p}{printf (p%2?$0"^"0"\n"}' file
yinyuemi 发表于 2011-01-26 00:22

bash-2.03$ awk '/"/{++p}{printf (p%2?$0"^"0"\n"}' test.csv
awk: syntax error near line 1
awk: illegal statement near line 1
bash-2.03$