python_批量转换腾讯云短信模版格式

近期需要同时申请多个腾讯云短信模版，因此写了一段python脚本进行批量转换。业务提供的原短信模版在第五列，我将第五列的短信模版转换好后放在了新文件的第六列，前五列和原始csv文件的数据保持一致。

代码如下：

# coding: utf8
import csv
import re
import sys

reload(sys)
sys.setdefaultencoding('utf8')
FILE_PATH = "C:\Users\wangke\Desktop\sms.csv"
NEW_FILE_PATH = "C:\Users\wangke\Desktop\sms_new.csv"

def transferFileToTencentFormat(originFile,transFile):
    csvfile = file(originFile, 'rb')
    reader = csv.reader(csvfile)
    tfile = file(transFile, 'wb')
    writer = csv.writer(tfile)
    for line in reader:
        originTemplateText = str(line[4].decode('GB2312'))
        tencentTemplateText = str(transferSmsTextToTencentFormat(originTemplateText)).encode("GB2312")
        #line.append(tencentTemplateText)
        line[5]=tencentTemplateText
        writer.writerow(line)

    csvfile.close()
    tfile.close()

def transferSmsTextToTencentFormat(orginText):
    m = re.compile('\[.+?\]')
    res = m.findall(orginText)
    for index,val in enumerate(res):
        orginText = orginText.replace(val,"{"+str(index)+"}",1)
    return orginText

if __name__=='__main__':
    transferFileToTencentFormat(FILE_PATH,NEW_FILE_PATH)

业务提供的模版

尊敬的[短信接收人姓名][先生\女士]，您于[保全申请日]申请的[保单号]号保单的[保全项目名称]已经于[保全生效日]生效，特此提示。如需帮助请关注“XXXX”官方微信或致电-XXX-XXXX

转换后的格式

尊敬的{0}{1}，您于{2}申请的{3}号保单的{4}已经于{5}生效，特此提示。如需帮助请关注“XXXX”官方微信或致电-XXX-XXXX