IF(物料编号="101*","铁线",if(物料编号="102*","铁管",if(物料编号="201*","锥套&内塞",""))),怎么写判定是否为某个字符串开头的语句
SWITCH(LEFT(物料编号,3),"101","铁线","102","铁管","201","锥套")
参考文档
https://help.fanruan.com/finebi/doc-view-360.html