awk 分隔符 多个空格,AWK使用多个空格作为分隔符

I am using below command to join two files using first two columns.

awk 'NR==FNR{a[$1,$2]=substr($0,3);next} ($1,$2) in a{print $0, a[$1,$2] > "br0102_3.txt"}' br01.txt br02.txt

Now, by default AWk command uses whitespaces as the separators. But my file may contain single space between two words, e.g.

File 1:

ABCD TEXT1 TEXT2 123123112312312312312312312312312312

BCDEFG TEXT3TEXT4 133123123123123123123123123125423423

QWERT TEXT5TEXT6 123123123123125456678786789698758567

File 2:

ABCD TEXT1 TEXT2 12312312312312312312312312312

BCDEFG TEXT3TEXT4 31242342342342342342342342343

MNHT TEXT8 TEXT9 31242342342342342342342342343

I want the result file as ;

ABCD TEXT1 TEXT2 123123112312312312312312312312312312 12312312312312312312312312312

BCDEFG TEXT3TEXT4 133123123123123123123123123125423423 31242342342342342342342342343

QWERT TEXT5TEXT6 123123123123125456678786789698758567

MNHT TEXT8 TEXT9 31242342342342342342342342343

Any hints ?

解决方案

awk supports a regular expression as the value of FS so you can specify a regular expression that matches at least two spaces. Something like -F '[[:space:]][[:space:]]+'.

$ awk '{print NF}' File2

4

3

4

$ awk -F '[[:space:]][[:space:]]+' '{print NF}' File2

3

3

3

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值