文本处理

zsszss0000

在 vim 中打开  原始文本 在命令行模式下输入

1. :％s/\(.*\)/ select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in ('\1');/g

复制代码

即可。。。。

jcdiy0601

sed -r "s/.*/\(\'&\'\)\;/;iselect b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in " file
select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
('C03-4217499-4390464');
select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
('C03-8473006-1196029');
select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
('C03-8643511-3897621');
select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
('C03-6168838-3011236');
select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
('C03-1043117-2585643');
select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
('D01-8943832-9343544');
select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
('D01-5102042-2578762');
select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
('D01-2105627-6887102');
select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
('D01-4673776-6721425');
select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
('D01-4827708-6153861');

wjemail

1. ]# sed "s/.*/select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in \n ('&');/" q22
   
2. select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
   
3. ('C03-4217499-4390464');
   
4. select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
   
5. ('C03-8473006-1196029');
   
6. select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
   
7. ('C03-8643511-3897621');
   
8. select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
   
9. ('C03-6168838-3011236');
   
10. select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
    
11. ('C03-1043117-2585643');
    
12. select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
    
13. ('D01-8943832-9343544');
    
14. select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
    
15. ('D01-5102042-2578762');
    
16. select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
    
17. ('D01-2105627-6887102');
    
18. select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
    
19. ('D01-4673776-6721425');
    
20. select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in
    
21. ('D01-4827708-6153861');
    

复制代码

ll104567

awk '{print "select b.valule,a.event,a.match,a.function from match_item a,match_keys b where a.match  = b.match_keys and b.value in ";print "(\047"$0"\047);"}'