//截取字符串:
substr(org.org_name,0,instr(org.org_name,‘钻探’,1,1)-1) as branch_comp_name
//去除汉字:
translate(org1.org_name,’#’|| translate(org1.org_name,‘abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789’,’#’) ,’/’) as wellitem_name
//截取字符串:
substr(org.org_name,0,instr(org.org_name,‘钻探’,1,1)-1) as branch_comp_name
//去除汉字:
translate(org1.org_name,’#’|| translate(org1.org_name,‘abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789’,’#’) ,’/’) as wellitem_name