AWK:现场分隔器为双管道或更多 [英] AWK : Field Separator as Double Pipes or more

问题描述

我的数据:

-1||"A|AA"||aaa@ymail
-10||"B ||B|ttB||b|| bb@ymail
-7||C||c

我想用逗号,来交换双管道定界符||:

I want to exchange the double pipe delimiters || with a comma , like this:

awk -F'||' -v OFS="," '{$1=$1} 1' 2.txt

，但输出保持不变. 相反的情况(逗号分隔符为双竖线)有效:

but the output remains the same. The reverse case (comma delimiter to double pipe), however, works:

awk -F"," -v OFS="||" '{$1=$1} 1' 1.txt

我在做什么错了?

推荐答案

您需要对管道符号进行转义:

You need to escape the pipe symbol:

awk -F '[|][|]' -v OFS="," '{$1=$1}1'

这篇关于AWK:现场分隔器为双管道或更多的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！