帆软填报模式,如何把返回多个数组李三_123,王五_246转换成李三,王五 和123,246分别存进数据库表的a字段和b字段
JOINARRAY(MAPARRAY(Y3, left(Y3,FIND(Y3,'_')-1)),",")
JOINARRAY(MAPARRAY(Y3, MID(Y3,FIND(Y3,'_')+1,18)),",")这样写了不对
已开启填报提交时报错:
MAPARRAY(SPLIT("李三_123,王五_246",","),INDEXOFARRAY(SPLIT(item,"_"),1))
MAPARRAY(SPLIT("李三_123,王五_246",","),INDEXOFARRAY(SPLIT(item,"_"),2))