awk 選出匹配兩個4的行

haofang666777

8|1|2|1435019833|1435019843|1|1435019843,8|1.1|4|1435019843|1435019899 | 095-1435019832.528
8|1|2|1435020072|1435020090|1|1435020090,8|1.1|4|1435020090|1435020092 | 095-1435020071.552
8|1|2|1435014250|1435014264|4|1435014264,8|1.4|4|1435014264|1435014417 | 095-1435014249.242
21|1|2|1435025043|1435025060|1|1435025060,21|1.1|2|1435025060|1435025068|1|1435025068,21|1.1.1|4|1435025068|1435025121,8|1.5|4|1435025121|1435025195
這三行中 僅僅最后一行滿足條件
即 以','分割成 成N個域然后各個域中以'|'分割第3項為4,滿足條件的雨個數(shù)大于等于2的 挑選出來

21|1|2|1435025043|1435025060|1|1435025060,21|1.1|2|1435025060|1435025068|1|1435025068,21|1.1.1|4|1435025068|1435025121,8|1.5|4|1435025121|1435025195

bianlimit

回復 1# haofang666777


   
8|1|2|1435019833|1435019843|1|1435019843,8|1.1|4|1435019843|1435019899 | 095-1435019832.528
8|1|2|1435020072|1435020090|1|1435020090,8|1.1|4|1435020090|1435020092 | 095-1435020071.552
8|1|2|1435014250|1435014264|4|1435014264,8|1.4|4|1435014264|1435014417 | 095-1435014249.242
21|1|2|1435025043|1435025060|1|1435025060,21|1.1|2|1435025060|1435025068|1|1435025068,21|1.1.1|4|1435025068|1435025121,8|1.5|4|1435025121|1435025195

好多4

bianlimit

回復 1# haofang666777

1. $ awk -F ',' '{a=0;for(i=1;i<=NF;i++){split($i,t,"|");if(t[3]==4){a++}};if(a>=2){print $0}}' 1.txt
   
2. 21|1|2|1435025043|1435025060|1|1435025060,21|1.1|2|1435025060|1435025068|1|1435025068,21|1.1.1|4|1435025068|1435025121,8|1.5|4|1435025121|1435025195
   

復制代碼

haofang666777

bianlimit 發(fā)表于 2015-06-23 19:27
回復 1# haofang666777

選出含有符合條件的4的個數(shù)大于等于2的行

haofang666777

bianlimit 發(fā)表于 2015-06-23 19:32
回復 1# haofang666777

謝謝 可以選出

stupid_lee

屌絲青年這樣子

1. awk -F, '{c=0;for(i=0;i<=NF;i++){split($i,a,"|");if(a[3]==4)c++}}c>=2'

復制代碼

songyc_2015

回復 1# haofang666777

1. awk 'gsub(/(^|,)[^,\|]+\|[^,\|]+\|4\|[^,]+,?/,"&")>=2' file

復制代碼

wh7211

1. awk 'BEGIN{FS=","}{j=0;for(i=1;i<=NF;i++){split($i,a,"|");if(a[3]==4){j++}};if(j>=2){print $0}}' file

復制代碼

hjfeng1988

修改7樓的

1. awk 'gsub(/(^|,)[^|]+\|[^|]+\|4\|/,"&")>=2' file

復制代碼

dn833

1. grep -P '(^|,)((\d|\.)+\|){2}4\|.*,((\d|\.)+\|){2}4\|'

復制代碼