修改列2只用awk和sed [英] Modify column 2 only using awk and sed
本文介绍了修改列2只用awk和sed的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有3列的列表:
2547123456789,5391074043372870,639027123456789
我要修改第二列是这样的:
SED的/ \\([0-9] \\)\\([0-9] \\)/ \\ 2 \\ 1 / G',使之成为:3519700434738207
我的问题是我怎么在awk中的一行做/同时保持其他列不变的sed让我最后的文件有:
2547123456789,3519700434738207,639027123456789
感谢
解决方案
#!/ bin / sh的awk的-F,'{
的printf(%S,$ 1)
LEN =拆分($ 2,)
对于(i = 1; I< LEN;我+ = 2)
的printf(%s%S,一个第[i + 1]中,[I])
的printf(%S \\ n,$ 3)
}'/路径/要/输入/文件
输入
$猫INFILE
2547123456789,5391074043372870,639027123456789
1234567890123,1234567890123456,123456789012345
输出
awk的-F, '{printf(\"%s,\",$1);len=split($2,a,\"\");for(i=1;i<len;i+=2)printf(\"%s%s\",a[i+1],a[i]);printf(\",%s\
\",$3)}' ./infile
2547123456789,3519700434738207,639027123456789
1234567890123,2143658709214365,123456789012345
I have a list of 3 columns:
2547123456789,5391074043372870,639027123456789
I want to modify second column like this:
sed 's/\([0-9]\)\([0-9]\)/\2\1/g' so that it becomes:
3519700434738207
My problem is how do I do this in one line of awk/sed while leaving the other columns untouched so that my final file has:
2547123456789,3519700434738207,639027123456789
Thanks
解决方案
#!/bin/sh
awk -F, '{
printf("%s,",$1)
len=split($2,a,"")
for(i=1;i<len;i+=2)
printf("%s%s",a[i+1],a[i])
printf(",%s\n",$3)
}' /path/to/input/file
Input
$ cat infile
2547123456789,5391074043372870,639027123456789
1234567890123,1234567890123456,123456789012345
Output
awk -F, '{printf("%s,",$1);len=split($2,a,"");for(i=1;i<len;i+=2)printf("%s%s",a[i+1],a[i]);printf(",%s\n",$3)}' ./infile
2547123456789,3519700434738207,639027123456789
1234567890123,2143658709214365,123456789012345
这篇关于修改列2只用awk和sed的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文