IF(INARRAY("/",REVERSEARRAY(SPLIT($formletname,"")))>0,RIGHT($formletname,INARRAY("/",REVERSEARRAY(SPLIT($formletname,"")))-1),$formletname) IF(LEN($reportname)>0, IF(INARRAY("/",REVERSEARRAY(SPLIT($reportname,"")))>0,RIGHT($reportname,INARRAY("/",REVERSEARRAY(SPLIT($reportname,"")))-1),$reportname) , IF(INARRAY("/",REVERSEARRAY(SPLIT($formletname,"")))>0,RIGHT($formletname,INARRAY("/",REVERSEARRAY(SPLIT($formletname,"")))-1),$formletname) ) (这个可以判断是普通还是决策,但是文件后缀名确实不容易去除)
赞 0 2021-01-29 12:55
嗯,根据实际情况需要灵活应用
赞 0 2019-04-09 00:27
我是这么来的 replace(RIGHT(reportName,len(reportName)-StringFind(reportName,"/",false)-1),".cpt","")把.cpt同时也去掉了
赞 1 2019-02-03 11:23
为啥你这个公式一用就模版报错打不开了
赞 0 2021-01-29 11:47
frm:不当人?
赞 1 2020-08-11 15:54
11 评论
IF(INARRAY("/",REVERSEARRAY(SPLIT($formletname,"")))>0,RIGHT($formletname,INARRAY("/",REVERSEARRAY(SPLIT($formletname,"")))-1),$formletname)
IF(LEN($reportname)>0,
IF(INARRAY("/",REVERSEARRAY(SPLIT($reportname,"")))>0,RIGHT($reportname,INARRAY("/",REVERSEARRAY(SPLIT($reportname,"")))-1),$reportname)
,
IF(INARRAY("/",REVERSEARRAY(SPLIT($formletname,"")))>0,RIGHT($formletname,INARRAY("/",REVERSEARRAY(SPLIT($formletname,"")))-1),$formletname)
)
(这个可以判断是普通还是决策,但是文件后缀名确实不容易去除)
赞 0 2021-01-29 12:55
嗯,根据实际情况需要灵活应用
赞 0 2019-04-09 00:27
我是这么来的 replace(RIGHT(reportName,len(reportName)-StringFind(reportName,"/",false)-1),".cpt","")把.cpt同时也去掉了
赞 1 2019-02-03 11:23
为啥你这个公式一用就模版报错打不开了
赞 0 2021-01-29 11:47
frm:不当人?
赞 1 2020-08-11 15:54