- 论坛徽章:
- 1
|
- [root@source ~]# cat a
- insert into t values(1,'abc',78,'greger2343','grtg');
- insert into t values(2,'dgre',44,'jty','grtg');
- insert into t values(3,'grhg',65,'66k','ghre');
- insert into t values(4,'muy',68,'yj','g5');
- insert into t values(5,'54yn',98,'67','54h');
- [root@source ~]# ./abc.py 5
- insert into t values('1', 'abc', '78', 'greger2343');
- insert into t values('2', 'dgre', '44', 'jty');
- insert into t values('3', 'grhg', '65', '66k');
- insert into t values('4', 'muy', '68', 'yj');
- insert into t values('5', '54yn', '98', '67');
- [root@source ~]# ./abc.py 4
- insert into t values('1', 'abc', '78', 'grtg');
- insert into t values('2', 'dgre', '44', 'grtg');
- insert into t values('3', 'grhg', '65', 'ghre');
- insert into t values('4', 'muy', '68', 'g5');
- insert into t values('5', '54yn', '98', '54h');
- [root@source ~]# cat abc.py
- #!/usr/bin/env python
- import re
- import sys
- f=open("/root/a")
- lines=f.readlines()
- for i in lines:
- k=re.search('([^(]*).*(;)',i)
- valuelist=re.findall('(?<=,|\().*?(?=,|\))',i)
- del valuelist[int(sys.argv[1])-1]
- str1=k.group(1)+str(tuple(valuelist))+k.group(2)
- print re.sub('"','',str1)
- f.close()
复制代码 |
|