100457
当asd登录过后填报时自动显示填报公司为B公司;
当123登录过后填报时自动显示填报公司为C公司;
自己用原来带有的公司拼啦一个,感觉很复杂,有什么好的办法吗?
MID(RIGHT(GREPARRAY($fr_userposition,FIND("财务人",item) != 0),LEN(INDEXOFARRAY(GREPARRAY($fr_userposition,FIND("财务人",item) != 0),1))-FIND("departments",GREPARRAY($fr_userposition,FIND("财务人",item) != 0))+1),FIND(",",RIGHT(GREPARRAY($fr_userposition,FIND("财务人",item) != 0),LEN(INDEXOFARRAY(GREPARRAY($fr_userposition,FIND("财务人",item) != 0),1))-FIND("departments",GREPARRAY($fr_userposition,FIND("财务人",item) != 0))+1),1)+1,FIND(",",RIGHT(GREPARRAY($fr_userposition,FIND("财务人",item) != 0),LEN(INDEXOFARRAY(GREPARRAY($fr_userposition,FIND("财务人",item) != 0),1))-FIND("departments",GREPARRAY($fr_userposition,FIND("财务人",item) != 0))+1),FIND(",",RIGHT(GREPARRAY($fr_userposition,FIND("财务人",item) != 0),LEN(INDEXOFARRAY(GREPARRAY($fr_userposition,FIND("财务人",item) != 0),1))-FIND("departments",GREPARRAY($fr_userposition,FIND("财务人",item) != 0))+1)))-FIND(",",RIGHT(GREPARRAY($fr_userposition,FIND("财务人",item) != 0),LEN(INDEXOFARRAY(GREPARRAY($fr_userposition,FIND("财务人",item) != 0),1))-FIND("departments",GREPARRAY($fr_userposition,FIND("财务人",item) != 0))+1),1)-1)