去除(和)两个字符

insert overwrite table zzsfp_hwmx select translate(trim(fp_nid),'%[(]',''), date_key,hwmc,ggxh,dw,sl,dj,je,se,translate(trim(spbm),'%[(]','') from zzsfp_hwmx;

posted @ 2021-10-10 21:09  xjspyx  阅读(64)  评论(0编辑  收藏  举报