11 评论

测试D2=1.3，可是SPLIT(D2,".") 显示为空

赞 0 2023-12-11 09:24

INDEXOFARRAY(SPLIT($$$,"/"),LEN($$$)) 简单一点

赞 0 2023-06-20 09:59

GETCHARNUM("demo/homepage/finereport.frm","/")
MIDCHAR("demo/homepage/finereport.frm","/",GETCHARNUM("demo/homepage/finereport.frm","/"))
新版本的可以这么写

赞 0 2023-03-14 11:32

=MIDCHAR("demo/homepage/finereport.frm","/",-1)
=MIDCHAR("demo/homepage/finereport.frm","/",GETCHARNUM("demo/homepage/finereport.frm","/"))

赞 0 2023-03-14 11:33

left(RIGHT($$$,INARRAY("/",REVERSEARRAY(SPLIT($$$,"")))-1),LEN(RIGHT($$$,INARRAY("/",REVERSEARRAY(SPLIT($$$,"")))-1))-4)
最后用left 来截取一下 实际去除文件后缀的长度。【len返回字符长度减去文件后缀的长度 得到实际文件字符长度】

赞 0 2022-09-08 17:09

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:59