求一条处理语句

gdcooler

Insert into T(ID,NAME, DESC, MEMO, STAT) Values (4, '张三', '132', '12', 'S0A');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (5, '李四', '132', '12', 'S0A');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (6, '王五', '132', '12', 'S0A');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (7, '小陈', '132', '12', 'S0A');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (9, '小李', '132', '12', 'S0A');
……………………
………………

现在把这个文件变成
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (4, '张三', '132', '12', 'S0A');
delete  from t where ID='4';
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (5, '李四', '132', '12', 'S0A');
delete  from t where ID='5';
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (6, '王五', '132', '12', 'S0A');
delete  from t where ID='6';
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (7, '小陈', '132', '12', 'S0A');
delete  from t where ID='7';
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (9, '小李', '132', '12', 'S0A');
delete  from t where ID='9';

意思是，在每条对应的添加语句的行后添加对于他的删除语句。

Shell_HAT

1. 
   
2. sed "s/.*Values (\([0-9]\+\),.*/&\ndelete from t where ID='\1';/g" urfile
   

复制代码

iori809

回复 2# Shell_HAT


    秒~我还想着用append呢

gdcooler

非常好用，谢谢大哥。。
拿回去研究研究。。。

gdcooler

追加一些问题，如果待处理的数据是：
Insert into T(ID,NAME, DESC, MEMO, STAT) Values ('4', '张三', '132', '12', 'S0A');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values ('5', '李四', '132', '12', 'S0A');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values ('6', '王五', '132', '12', 'S0A');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values ('7', '小陈', '132', '12', 'S0A');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values ('9', '小李', '132', '12', 'S0A');
……
……

应该怎么变动语句呢？

gdcooler

ID由原来的数字变成string

jerryjzm

[monitor@test ~]$ more 1.txt
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (4,'脮脠', ,'132','12','S0A');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (5,'脌脣', ,'132','12','S0A');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (6,'脥脦', ,'132','12','S0A');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (7,'小鲁脗, ','132','12' 'S,'SOA');
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (9,'小脌', ,'132','12','S0A');
[monitor@test ~]$ sed "s#\(.*Values (\)\(.\)\(.*\)#\1\2\3\ndelete  from t where ID='\2;'#" 1.txt  
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (4,'脮脠', ,'132','12','S0A');
delete  from t where ID='4;'
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (5,'脌脣', ,'132','12','S0A');
delete  from t where ID='5;'
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (6,'脥脦', ,'132','12','S0A');
delete  from t where ID='6;'
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (7,'小鲁脗, ','132','12' 'S,'SOA');
delete  from t where ID='7;'
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (9,'小脌', ,'132','12','S0A');
delete  from t where ID='9;'
[monitor@test ~]$

我也想用append，但是那个参数如何带下来
[monitor@test ~]$ sed "/Values (\(.\),/a delete  from t where ID='\1';" 1.txt                        
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (4,'脮脠', ,'132','12','S0A');
delete  from t where ID='1';
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (5,'脌脣', ,'132','12','S0A');
delete  from t where ID='1';
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (6,'脥脦', ,'132','12','S0A');
delete  from t where ID='1';
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (7,'小鲁脗, ','132','12' 'S,'SOA');
delete  from t where ID='1';
Insert into T(ID,NAME, DESC, MEMO, STAT) Values (9,'小脌', ,'132','12','S0A');
delete  from t where ID='1';
[monitor@test ~]$

Shell_HAT

回复 5# gdcooler

1. 
   
2. sed "s/Values ('\([0-9]\+\)'.*/&\ndelete from t where ID='\1';/g" urfile
   

复制代码