关于ses，awk，grep文本过滤工具的应用

Linux9253

1. ID        YWQQID        SQRQ        SQSJ        KHH        FUNC        FUNC_NAME        FID        CLRQ        CLSJ        CLZT        CB_CLZT        ISLOCK        RETRY        REQ_DATA        CDATA        TASK_DATA
   
2. 
   
3. 
   
4. 30191        -1        20141023        10:44:12        10000040228        YHZHGL_CGZHKH        存管银户        #VALUE!        20141023        10:44:13        8        0        0     {"req_data":{"zjlb":"0","fqqd":"2","fqgydm":"90016101","yhzh":"6260605899810","khh":"010000040228","remark":"","bz":"1","khqz":"620","czzd":"114.81.254.172","jmlx":"3","khyyb":"0100","zzjzh":"10253604","zjbh":"330427610140070","zjzh":"10253604","khmc":"王小","fqr":"90016101","yhdm":"GDYH","cgzdfs":"1","khfs":"3","yhmm":"I6IJgPG1b74mWKXUVk06t9y2Xfako+OoHIUyD/gBXq8=","ywxt":"1000","zhlb":"1","ywzh":"010000040228","gtzjzh":"01000004022801"},"func":"YHZHGL_CGZHKH","stype":"service","ywqqclid":30191,"ywzh":"010000040228"}        {"clzt":8,"code":111,"code_hb":111,"code_sq":1,"dfsqh":"1417","func":"YHZHGL_CGZHKH","note":"业务回报功","note_hb":"业务回报","note_sq":"申请","yhcgzh":"6226660605810","ywqqclid":30191,"ywxt":1000,"ywzh":"010000040228"}        {}
   
5. 
   
6. 
   
7. 29270        -1        20141021        15:07:56        1000040223        YHZHGL_CGZHKH        存管银行开户        -1        20141021        15:07:58        8        0        0     {"req_data":{"zjlb":"0","fqqd":"2","fqgydm":"90016101","yhzh":"62225203168","khh":"010000040223","remark":"","bz":"1","khqz":"0100","czzd":"114.90.32.98","jmlx":"3","khyyb":"0100","zzjzh":"10252004","zjbh":"4306108031519","zjzh":"10252004","khmc":"李行","fqr":"90016101","yhdm":"PFYH","cgzdfs":"1","khfs":"2","yhmm":"/hwIKEdC5wqoicSbWsQSe/UejoZ05D0LJU7fSGZXI8c=","ywxt":"1000","zhlb":"1","ywzh":"010000040223","gtzjzh":"01000022301"},"func":"YHZHGL_CGZHKH","stype":"service","ywqqclid":29270,"ywzh":"0100040223"}        {"clzt":8,"code":111,"code_hb":111,"code_sq":1,"dfsqh":"1990","func":"YHZHGL_CGZHKH","note":"业务回报成功","note_hb":"业务回报成功","note_sq":"申请成功","yhcgzh":"622522013168","ywqqclid":29270,"ywxt":1000,"ywzh":"01000040223"}        {}

复制代码

这是一个文件、共三行（现实中不止三行），第一行是对应的字段id，后两行的格式一样，
简单的来说格式是这样的

1. [root@localServer ~]# vim adm
   
2. 1   2   3   4   
   
3. z   x   c   d   q：w,r：y
   
4. q   w   e   r   q：t,r：i

复制代码

处理成

1. 2   3   q   r
   
2. x   c   w   y

复制代码

也就是说、第一行有的字段，打印出来，没有的，打印出所得结果“：”前面的内容
比如查找x，w这一列，第一行有2，那么打印出来、但要是打印y，i的话、第一行就没有了、那么就打印y，i冒号之前的内容到第一行
现在我要KHH，CLZT，yhdm，khmc，zjbh，ywqqclid，这几个字段，前两个KHH，CLZT位置是固定的
yhdm，khmc，zjbh，ywqqclid这几个字段都是属于例子中q：w,r：y的位置，但q和r的前后位置不固定






这是我写的、本来是可以的。但如果q和r的位置变了、就行不通了。请大牛帮忙。。。。

liion631818

真的没看懂要做什么

jason680

回复 1# Linux9253

It's hard to know what you say, but I guess ...

$ awk -vs="KHH CLZT yhdm khmc zjbh ywqqclid" 'NR==1{ac=split(s,a," ");print s;for(c=1;c<=ac;c++){m=0;for(n=1;n<=NF;n++)if(a[c]==$n)an[c]=n}next}NF>1{gsub("} +{",",");gsub("[{}\"]","");bc=split($NF,b,"[:,]");if(!C++)for(c=1;c<=ac;c++)if(!an[c])for(n=1;n<=bc;n++)if(b[n]==a[c])bn[c]=n+1;p=$an[1];for(c=2;c<=ac;c++){p=p" "(an[c]?$an[c]:b[bn[c]])};print p}' FILE | column -t
KHH          CLZT  yhdm  khmc  zjbh             ywqqclid
10000040228  8     GDYH  王小  330427610140070  30191
1000040223   8     PFYH  李行  4306108031519    29270

Linux9253

回复 3# jason680


   
非常感谢你的回答。很符合我的格式要求，但为什么我执行后是这样的？
少了几个字段

jason680

回复 4# Linux9253

modify

gsub("} +{",",");

gsub("}[\t ]+{",",");
   

tuyajie

好多程序媛啊。。。。