去除(和)两个字符

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;

原文地址:https://www.cnblogs.com/zhaoyuxiao000/p/15390704.html