bash 将换行符替换为引号

Question

我有以下 CSV 文件:

"test","test2","test
3 and some other

data"
"test4","test5","test6 and some other


data"

我想用字符 \n 替换所有的换行符(windows 或 unix 风格)，所以我会得到:

"test","test2","test\n3 and some other\n\ndata"
"test4","test5","test6 and some other\n\n\ndata"

我试过 awk 但没有成功:

cat myFile.csv | awk -F \" -v OFS=\" '{
   for (i=0; i<NF; i++) {
      gsub("\\n", "\\\\n", $i)
   }
   print
}'

Answer 1

这是一种方法:

$ awk '!/"$/{sub(/$/,"\\n");printf "%s",$0;next}1' file
"test","test2","test\n3 and some other\n\ndata"
"test4","test5","test6 and some other\n\n\ndata"