将第一行内容改为第二行的内容格式
REPLACE INTO `LogCenterDbName` VALUES (29, 1, 'lt4_his');
REPLACE INTO `LogCenterDbName` VALUES (29, 1, 'loghis_pool1','pjbhislt4');
原文件
cat file.txt
REPLACE INTO `LogCenterDbName` VALUES (14, 0, 'dx1_log');
REPLACE INTO `LogCenterDbName` VALUES (14, 1, 'dx1_his');
REPLACE INTO `LogCenterDbName` VALUES (18, 0, 'dx2_log');
REPLACE INTO `LogCenterDbName` VALUES (18, 1, 'dx2_his');
REPLACE INTO `LogCenterDbName` VALUES (19, 0, 'dx3_log');
REPLACE INTO `LogCenterDbName` VALUES (19, 1, 'dx3_his');
REPLACE INTO `LogCenterDbName` VALUES (21, 1, 'dx4_his');
REPLACE INTO `LogCenterDbName` VALUES (21, 0, 'dx4_log');
REPLACE INTO `LogCenterDbName` VALUES (25, 0, 'dx5_log');
REPLACE INTO `LogCenterDbName` VALUES (25, 1, 'dx5_his');
REPLACE INTO `LogCenterDbName` VALUES (15, 0, 'lt1_log');
REPLACE INTO `LogCenterDbName` VALUES (15, 1, 'lt1_his');
REPLACE INTO `LogCenterDbName` VALUES (20, 0, 'lt2_log');
REPLACE INTO `LogCenterDbName` VALUES (20, 1, 'lt2_his');
REPLACE INTO `LogCenterDbName` VALUES (23, 0, 'lt3_log');
REPLACE INTO `LogCenterDbName` VALUES (23, 1, 'lt3_his');
REPLACE INTO `LogCenterDbName` VALUES (17, 0, '360_log');
REPLACE INTO `LogCenterDbName` VALUES (17, 1, '360_his');
REPLACE INTO `LogCenterDbName` VALUES (22, 0, '179_log');
REPLACE INTO `LogCenterDbName` VALUES (22, 1, '179_his');
REPLACE INTO `LogCenterDbName` VALUES (24, 0, 'yy_log');
REPLACE INTO `LogCenterDbName` VALUES (24, 1, 'yy_his');
REPLACE INTO `LogCenterDbName` VALUES (26, 0, '9377_log');
REPLACE INTO `LogCenterDbName` VALUES (26, 1, '9377_his');
REPLACE INTO `LogCenterDbName` VALUES (28, 0, 'dx6_log');
REPLACE INTO `LogCenterDbName` VALUES (28, 1, 'dx6_his');
REPLACE INTO `LogCenterDbName` VALUES (29, 0, 'lt4_log');
REPLACE INTO `LogCenterDbName` VALUES (29, 1, 'lt4_his');
脚本内容
#!/usr/bin/env python
#coding:utf-8
f=open('file.txt','r')
b=file('test.txt','a')
for i in f:
i=i.split("'")
q=i[1]
q=q.split('_')
zuo=q[0]
you=q[1]
format="'pjb%s%s'" % (you,zuo)
nr=str(i[0]+'loghis_pool1 ,'+format+i[2],)
b.write(nr)
f.close()
b.close()
修改后的文件内容
cat test.txt
REPLACE INTO `LogCenterDbName` VALUES (14, 0, loghis_pool1 ,'pjblogdx1');
REPLACE INTO `LogCenterDbName` VALUES (14, 1, loghis_pool1 ,'pjbhisdx1');
REPLACE INTO `LogCenterDbName` VALUES (18, 0, loghis_pool1 ,'pjblogdx2');
REPLACE INTO `LogCenterDbName` VALUES (18, 1, loghis_pool1 ,'pjbhisdx2');
REPLACE INTO `LogCenterDbName` VALUES (19, 0, loghis_pool1 ,'pjblogdx3');
REPLACE INTO `LogCenterDbName` VALUES (19, 1, loghis_pool1 ,'pjbhisdx3');
REPLACE INTO `LogCenterDbName` VALUES (21, 1, loghis_pool1 ,'pjbhisdx4');
REPLACE INTO `LogCenterDbName` VALUES (21, 0, loghis_pool1 ,'pjblogdx4');
REPLACE INTO `LogCenterDbName` VALUES (25, 0, loghis_pool1 ,'pjblogdx5');
REPLACE INTO `LogCenterDbName` VALUES (25, 1, loghis_pool1 ,'pjbhisdx5');
REPLACE INTO `LogCenterDbName` VALUES (15, 0, loghis_pool1 ,'pjbloglt1');
REPLACE INTO `LogCenterDbName` VALUES (15, 1, loghis_pool1 ,'pjbhislt1');
REPLACE INTO `LogCenterDbName` VALUES (20, 0, loghis_pool1 ,'pjbloglt2');
REPLACE INTO `LogCenterDbName` VALUES (20, 1, loghis_pool1 ,'pjbhislt2');
REPLACE INTO `LogCenterDbName` VALUES (23, 0, loghis_pool1 ,'pjbloglt3');
REPLACE INTO `LogCenterDbName` VALUES (23, 1, loghis_pool1 ,'pjbhislt3');
REPLACE INTO `LogCenterDbName` VALUES (17, 0, loghis_pool1 ,'pjblog360');
REPLACE INTO `LogCenterDbName` VALUES (17, 1, loghis_pool1 ,'pjbhis360');
REPLACE INTO `LogCenterDbName` VALUES (22, 0, loghis_pool1 ,'pjblog179');
REPLACE INTO `LogCenterDbName` VALUES (22, 1, loghis_pool1 ,'pjbhis179');
REPLACE INTO `LogCenterDbName` VALUES (24, 0, loghis_pool1 ,'pjblogyy');
REPLACE INTO `LogCenterDbName` VALUES (24, 1, loghis_pool1 ,'pjbhisyy');
REPLACE INTO `LogCenterDbName` VALUES (26, 0, loghis_pool1 ,'pjblog9377');
REPLACE INTO `LogCenterDbName` VALUES (26, 1, loghis_pool1 ,'pjbhis9377');
REPLACE INTO `LogCenterDbName` VALUES (28, 0, loghis_pool1 ,'pjblogdx6');
REPLACE INTO `LogCenterDbName` VALUES (28, 1, loghis_pool1 ,'pjbhisdx6');
REPLACE INTO `LogCenterDbName` VALUES (29, 0, loghis_pool1 ,'pjbloglt4');
REPLACE INTO `LogCenterDbName` VALUES (29, 1, loghis_pool1 ,'pjbhislt4');