如何输出多个文件中的指定几个字段？

elu_ligao

回复 1# johnson0418

1. awk -vRS="[()\n]+" 'FNR==7||FNR==5||FNR==21||FNR==81||FNR==25||FNR==31||FNR==35{gsub(/[[:space:]]+$/,"");split($0,s,/=/);a[s[1]]=a[s[1]]?a[s[1]]"|"s[2]:s[2]}END{for(i in a)print i"|"a[i]}' *.DAT | awk -F\| '{for(i=1;i<=NF;++i)b[NR,i]=$i}END{for(i=1;i<=NF;++i){for(j=1;j<=NR;++j)printf("%-20s", b[j,i]);print ""}}'

复制代码

haooooaaa

1. awk -vRS= -F=' *\\(' -vs='ChargedNumber       CalledNumber        CallType            StartDateTime       EndDateTime         Duration            TrunkGroupIdentity' 'BEGIN{p=split(s,t,"  *");print s}a!=FILENAME{if(a)print m;a=FILENAME}{for(i=1;i<=p;i++){if(match($0,t[i]" = ([^(\n]+)",n)){sub(" *$","",n[1]);printf "%-20 s",n[1]}}}' *

复制代码

johnson0418

回复 4# haooooaaa

users>more dd
awk -vRS= -F=' *\\(' -vs='ChargedNumber       CalledNumber        CallType            StartDateTime       EndDateTi
me         Duration            TrunkGroupIdentity' 'BEGIN{p=split(s,t,"  *");print s}a!=FILENAME{if(a)print m
;a=FILENAME}{for(i=1;i<=p;i++){if(match($0,t" = ([^(\n]+)",n)){sub(" *$","",n[1]);printf "%-20 s",n[1]}}}' *

users>./dd
awk: cmd. line:1: fatal: match() cannot have 3 arguments


    awk: option requires an argument -- W
Usage: awk [POSIX or GNU style options] -f progfile [--] file ...
        awk [POSIX or GNU style options] [--] 'program' file ...
POSIX options:                GNU long options:
        -f progfile                --file=progfile
        -F fs                        --field-separator=fs
        -v var=val                --assign=var=val
        -m[fr] val
        -W compat                --compat
        -W copyleft                --copyleft
        -W copyright                --copyright
        -W help                        --help
        -W lint                        --lint
        -W lint-old                --lint-old
        -W posix                --posix
        -W re-interval                --re-interval
        -W source=program-text        --source=program-text
        -W traditional                --traditional
        -W usage                --usage
        -W version                --version

To report bugs, see node `Bugs' in `gawk.info', which
is section `Reporting Problems and Bugs' in the
printed version.
(1)xa000000> awk --version
GNU Awk 3.0.6
Copyright (C) 1989, 1991-2000 Free Software Foundation.

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.

johnson0418

回复 2# elu_ligao


users>more ff
awk -vRS="[()\n]+" 'FNR==7||FNR==5||FNR==21||FNR==81||FNR==25||FNR==31||FNR==35{gsub(/[[:space:]]+$/,"");split($0,s
,/=/);a[s[1]]=a[s[1]]?a[s[1]]"|"s[2]:s[2]}END{for(i in a)print i"|"a}' *.DAT | awk -F\| '{for(i=1;i<=NF;++i)b[
NR,i]=$i}END{for(i=1;i<=NF;++i){for(j=1;j<=NR;++j)printf("%-20s", b[j,i]);print ""}}'

users> ./ff
09                  39                  01                  11                  02                  14                  16        

输出的是标题，非内容！！

elu_ligao

你的 awk 版本不同， 3楼4楼的都能输出你要的结果的， 当然我那个也是可以的， 但3 4 楼的更通用， 按你关键字来的， 你文件里面只要有这些关键字的配置都能取出来， 把你awk 版本贴出来看看吧

johnson0418

回复 8# elu_ligao

你的方法我可以执行，但就是输出的内容不对。麻烦你在看看是不是有的字段写的不对？
3楼的太复杂了，我搞不明白。
4楼的在我的设备里不能执行，但在redhat 9里是可以的。但我需要在我的设备里执行，且不能升级AWK。
users> awk --version
GNU Awk 3.0.6
Copyright (C) 1989, 1991-2000 Free Software Foundation.

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.