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

yinyuemi

回复 40# clonescopy


    我这里测试问题

加个转义\符号试试，awk '/\"/{++p}{printf (p%2?$0"^"0"\n"}'

$ bash --version
bash --version
GNU bash, version 3.2.49(23)-release (i686-pc-cygwin)
Copyright (C) 2007 Free Software Foundation, Inc.

clonescopy

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$

blackold

回复 42# clonescopy


    环境问题。

try  nawk ...

clonescopy

bash-2.03$ nawk '/\"/{++p}{printf (p%2?$0"^"0"\n"}' test.csv
a,b,"c^d^",111
e,f,"c^d^",222
bash-2.03$

禁飞区

sed 's/\\n//g;s/$/&\\n/g' ufile

文件只有两行, 看来是纯练习.

blackold

回复 44# clonescopy

1. nawk 'BEGIN{RS=ORS="\r\n"}gsub(/\n/,"")""' urfile

复制代码

clonescopy

回复  clonescopy
blackold 发表于 2011-01-26 16:57

1. bash-2.03$ nawk 'BEGIN{RS=ORS="\r\n"}gsub(/\n/,"")""' test.csv
   
2. a,b,"cd",111
   
3. e,f,"cd",222
   
4. 
   
5. bash-2.03$

复制代码