一、提取(前的字符串
LEFT([产品名],FIND([产品名],"(")-1)
二、提取()内的字符串
mid([产品名],FIND([产品名],"(")+1,FIND([产品名],")")-FIND([产品名],"(")-1)
三、提取)后的字符串
RIGHT([产品名],len([产品名])-FIND([产品名],")"))
一、提取(前的字符串
LEFT([产品名],FIND([产品名],"(")-1)
二、提取()内的字符串
mid([产品名],FIND([产品名],"(")+1,FIND([产品名],")")-FIND([产品名],"(")-1)
三、提取)后的字符串
RIGHT([产品名],len([产品名])-FIND([产品名],")"))