用shell实现查找

kenny_hs

Users:rop_rx@101.103.34.30
Users:rop_rx@101.103.34.101
Users:rop_rx@101.103.64.154
Users:rop_rx@101.103.34.41
Users:rop_rx@101.103.64.211
Users:rop_rx@101.103.64.210
Users:rop_rx@101.103.64.100
Query:UPDATE anc_cj SET time='S', lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
Users:rop_rx@101.103.64.211
Users:rop_rx@101.103.64.210
Users:rop_rx@101.103.64.109
Query:UPDATE anc_cj SET  lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
Users:rop_rx@101.103.64.109
Query:UPDATE anc_cj SET qulity='S',addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N

当找到Users:rop_rx@101.103.64.211这个时，将下面的Query打印出来，其他用户Users不打印出来
如：
Users:rop_rx@101.103.64.211
Query:UPDATE anc_cj SET time='S', lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
Users:rop_rx@101.103.64.211
Query:UPDATE anc_cj SET  lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
而查找Users:rop_rx@101.103.34.30打印结果如下
Users:rop_rx@101.103.34.30
Query:UPDATE anc_cj SET time='S', lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
请问怎么实现

kenny_hs

回复 7# ljwd1000


    非常感谢

ljwd1000

1. [root@test /]# awk -v ip="101.103.64.211" '$0~ip{x=$0;while(getline a)if(a~/^Query/){print x"\n"a;break}}' ip.sql
   
2. Users:rop_rx@101.103.64.211
   
3. Query:UPDATE anc_cj SET time='S', lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
   
4. Users:rop_rx@101.103.64.211
   
5. Query:UPDATE anc_cj SET  lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
   
6. [root@test /]# cat ip.sql
   
7. Users:rop_rx@101.103.34.30
   
8. Users:rop_rx@101.103.34.101
   
9. Users:rop_rx@101.103.64.154
   
10. Users:rop_rx@101.103.34.41
    
11. Users:rop_rx@101.103.64.211
    
12. Users:rop_rx@101.103.64.210
    
13. Users:rop_rx@101.103.64.100
    
14. Query:UPDATE anc_cj SET time='S', lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
    
15. Users:rop_rx@101.103.64.211
    
16. Users:rop_rx@101.103.64.210
    
17. Users:rop_rx@101.103.64.109
    
18. Query:UPDATE anc_cj SET  lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
    
19. Users:rop_rx@101.103.64.109
    
20. Query:UPDATE anc_cj SET qulity='S',addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N

复制代码

回复 4# kenny_hs


哪里不对？没看出来

   

dn833

1. awk 'BEGIN{RS="Users:rop_rx@101.103.64.211";FS="\n"}NR>1{print $(NF-1)}'

复制代码

一棵菠菜

1. awk -v i=$(awk '/Users:rop_rx@101.103.64.100/{a=NR+1;print a}' test) 'NR==i' test

复制代码

1. [root@zhenai1212 shell]# cat test
   
2. Users:rop_rx@101.103.34.30
   
3. Users:rop_rx@101.103.34.101
   
4. Users:rop_rx@101.103.64.154
   
5. Users:rop_rx@101.103.34.41
   
6. Users:rop_rx@101.103.64.211
   
7. Users:rop_rx@101.103.64.210
   
8. Users:rop_rx@101.103.64.100
   
9. Query:UPDATE anc_cj SET time='S', lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
   
10. Users:rop_rx@101.103.64.211
    
11. Users:rop_rx@101.103.64.210
    
12. Users:rop_rx@101.103.64.109
    
13. Query:UPDATE anc_cj SET  lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
    
14. Users:rop_rx@101.103.64.109
    
15. Query:UPDATE anc_cj SET qulity='S',addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N

复制代码

kenny_hs

回复 2# ljwd1000


    我把上面哪些放在一个文件里面ip.sql里面，好像实现不了

mcshell

回复 1# kenny_hs

1. #perl -lne 'if(/^Users:rop_rx\@101.103.64.211/../^Query/){$data .="$_\n" if/211$|^Query/ }END{print "$data"}' tmp
   
2. Users:rop_rx@101.103.64.211
   
3. Query:UPDATE anc_cj SET time='S', lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
   
4. Users:rop_rx@101.103.64.211
   
5. Query:UPDATE anc_cj SET  lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
   
6. #perl -lne 'if(/^Users:rop_rx\@101.103.34.30/../^Query/){$data .="$_\n" if/30$|^Query/ }END{print "$data"}' tmp                        
   
7.   Users:rop_rx@101.103.34.30
   
8. Query:UPDATE anc_cj SET time='S', lastedit=N ,addexplain=N ,modelpic=N ,roompic=N ,ishighqulity=N WHERE proid=N
   
9. 
   
10. 
    
11. 
    

复制代码

ljwd1000

1. awk -v ip="101.103.64.211" '$0~ip{x=$0;while(getline a)if(a~/^Query/){print x"\n"a;break}}' file

复制代码

这样？