python_re_module

1: select fdsa||fasdfers||wafdsf cfdm

select concat(fdsa,fasdfers,wafdsf) cfdm

2: to_date(#trxDate#,‘yyyyMMdd hh24:mi:ss‘)

str_to_date(#trxDate#,‘%y%m%d %h:%i:%s‘)

cankao:

text="to_date(#trxDate#,‘yyyyMMdd hh24:mi:ss‘)"
p=re.compile(r"(to_date)(.+?‘)([a-zA-Z])(\3+)([^a-zA-Z]?)([a-zA-Z])(\6+)([^a-zA-Z]?)([a-zA-Z])(\9+)(.+?):(.+?):(.+)")
p.sub(r"str_\1\2%\3\5%\6\8%\9 %H:%i%s‘",text)

python_re_module

原文：https://www.cnblogs.com/applejuice/p/12198351.html