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,满足条件的雨个数大于等于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 发表于 2015-06-23 19:27
回复 1# haofang666777

选出含有符合条件的4的个数大于等于2的行

haofang666777

bianlimit 发表于 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\|'

复制代码