两两有关联的三行合并成一行

_lpq

1.txt:
we:fr,123:000,LOG,U,01,103,03,0,Passed[0x0d]
ed:gf,123:000,LOG,B,01,52,01,0,Passed[0x0d]
fe:dD,123:000,LOG,PL,01,51,01,01,101,01[0x0d]
vf:be,123:000,LOG,P,01,51,01,0,Passed[0x0d]
dw:ue,123:000,LOG,L,01,101,01,0,Passed[0x0d]
re:mj,123:000,LOG,PL,01,51,01,01,101,03[0x0d]
ki:hn,123:000,LOG,P,01,51,01,0,Passed[0x0d]
jh:hy,123:000,LOG,L,01,101,03,0,Passed[0x0d]
yuc,123:000,LOG,PL,01,51,01,01,101,04[0x0d]
yt:XW,123:000,LOG,P,01,51,01,0,Passed[0x0d]
ry:fr,123:000,LOG,L,01,101,04,0,Passed[0x0d]
od:fr,123:000,LOG,PL,01,51,01,01,101,01[0x0d]
fe:ed,123:000,LOG,P,01,51,01,0,Passed[0x0d]
gd:de,123:000,LOG,L,01,101,01,0,Passed[0x0d]
dv:fe,123:000,LOG,UL,01,101,01,01,102,01[0x0d]
vd:ED,123:000,LOG,U,01,101,01,0,Passed[0x0d]
sf:vt,123:000,LOG,L,01,102,01,0,Passed[0x0d]
gf:gt,123:000,LOG,U,01,101,01,0,Passed[0x0d]
fr:we,123:000,LOG,L,01,102,01,0,Passed[0x0d]
df:r5,123:000,LOG,PL,01,51,01,01,101,01[0x0d]
wr:24,123:000,LOG,P,01,51,01,0,Passed[0x0d]
Xs:23,123:000,LOG,UL,01,101,01,01,102,01[0x0d]
fd:fd,123:000,LOG,U,01,101,01,0,fail[0x0d]
DD:ef,123:000,LOG,L,01,102,01,0,fail[0x0d]
WS:32,123:000,LOG,PB,01,21,01,01,103,01[0x0d]
fr:de,123:000,LOG,B,01,103,01,0,Passed[0x0d]
yt:34,123:000,LOG,PL,01,51,01,01,101,02[0x0d]
ut:56,123:000,LOG,P,01,51,01,0,Passed[0x0d]
yr:hy,123:000,LOG,L,01,101,02,0,Passed[0x0d]
re:gt,123:000,LOG,PB,01,51,01,01,12,01[0x0d]
gt:45,123:000,LOG,P,01,51,01,0,Passed[0x0d]
gt:r4,123:000,LOG,B,01,12,01,0,Passed[0x0d]


结果是：
000,LOG,PL,01,51,01,01,101,01[0x0d]|000,LOG,P,01,51,01,0,Passed[0x0d]|000,LOG,L,01,101,01,0,Passed[0x0d]
000,LOG,PL,01,51,01,01,101,03[0x0d]|000,LOG,P,01,51,01,0,Passed[0x0d]|000,LOG,L,01,101,03,0,Passed[0x0d]
000,LOG,PL,01,51,01,01,101,04[0x0d]|000,LOG,P,01,51,01,0,Passed[0x0d]|000,LOG,L,01,101,04,0,Passed[0x0d]
000,LOG,PL,01,51,01,01,101,01[0x0d]|000,LOG,P,01,51,01,0,Passed[0x0d]|000,LOG,L,01,101,01,0,Passed[0x0d]
000,LOG,UL,01,101,01,01,102,01[0x0d]|000,LOG,U,01,101,01,0,Passed[0x0d]|000,LOG,L,01,102,01,0,Passed[0x0d]
000,LOG,PL,01,51,01,01,101,02[0x0d]|000,LOG,P,01,51,01,0,Passed[0x0d]|000,LOG,L,01,101,02,0,Passed[0x0d]
000,LOG,PB,01,51,01,01,12,01[0x0d]|000,LOG,P,01,51,01,0,Passed[0x0d]|000,LOG,B,01,12,01,0,Passed[0x0d]

第一行的$5$6等于第二行的$5$6,第一行的$8$9等于第三行的$5$6,并且第二行和第三行$8=Passed[0x0d]
000,LOG,PL,01,51,01,01,101,01[0x0d]
000,LOG,P,01,51,01,0,Passed[0x0d]
000,LOG,L,01,101,01,0,Passed[0x0d]

谢了~

jason680

http://bbs.chinaunix.net/thread-4118053-1-1.html

haooooaaa

1. awk -F'[,[]' '{$0=substr($0,11)}/Passed/{if(a==$5$6)s=c"|"$0;if(b==$5$6){print s"|"$0;s=a=b=c=""}}NF>9{a=$5$6;b=$8$9;c=$0}'

复制代码

_lpq

回复 2# jason680


额，没讲请？
就是1.txt有3行，是一个关联
fe:dD,123:000,LOG,PL,01,51,01,01,101,01[0x0d]
vf:be,123:000,LOG,P,01,51,01,0,Passed[0x0d]
dw:ue,123:000,LOG,L,01,101,01,0,Passed[0x0d]


PL可分为P，L的两行
PL的那一行的51,01对应P的那一行的51,01
PL的那一行的101,01对应P的那一行的101,01
并且含P，L的两行还要有Passed[0x0d]



文本里还有UL，但是对应位置都是一样的
dv:fe,123:000,LOG,UL,01,101,01,01,102,01[0x0d]
vd:ED,123:000,LOG,U,01,101,01,0,Passed[0x0d]
sf:vt,123:000,LOG,L,01,102,01,0,Passed[0x0d]

_lpq

回复 3# haooooaaa

谢谢！

Wendys-Mac-miniesktop wendy$ awk -F'[,[]' '{$0=substr($0,11)}/Passed/{if(a==$5$6)s=c"|"$0;if(b==$5$6){print s"|"$0;s=a=b=c=""}}NF>9{a=$5$6;b=$8$9;c=$0}' /Users/wendy/Desktop/345767.txt

|000,LOG,L,01,101,01,0,Passed[0x0d]

|000,LOG,L,01,101,03,0,Passed[0x0d]

|000,LOG,L,01,101,04,0,Passed[0x0d]

|000,LOG,L,01,101,01,0,Passed[0x0d]

|000,LOG,L,01,102,01,0,Passed[0x0d]]

|000,LOG,B,01,103,01,0,Passed[0x0d]

|000,LOG,L,01,101,02,0,Passed[0x0d]

|000,LOG,B,01,12,01,0,Passed[0x0d]

Wendys-Mac-miniesktop wendy$

但是得不到结果

Wendys-Mac-miniesktop wendy$ bash --version

GNU bash, version 3.2.57(1)-release (x86_64-apple-darwin15)

Copyright (C) 2007 Free Software Foundation, Inc.

Wendys-Mac-miniesktop wendy$

zxy877298415

回复 1# _lpq

1. awk -F, 'function f(x,y) {return split(x,y,"[,[\\]]")}length($4)==2{a[++i]=$0;next}a[i]{a[i]=a[i]"  "$0}END{for(j=1;j<=i;j++) {t=split(a[j],b,"  ");if(t>=3){m=f(b[1],c);n=f(b[2],d);o=f(b[3],e);if(c[6]c[7]==d[6]d[7]&&c[m-3]c[m-2]==e[6]e[7]&&d[n-2]d[m-2]=="Passed0x0d"&&e[n-2]e[m-2]=="Passed0x0d") {print  gensub("..:..,...:","","G",b[1]b[2]b[3])}}}}' file

复制代码