INDEXOFARRAY(REVERSEARRAY(split('2022_file/1e2e8y6hwbdo9t3n.pdf,云审批字[2021]45号',",")),1)
![1653904729604748.png image.png](/upload/wenda/20220530/1653904729604748.png)
SQL SERVER:
只有一个逗号
SELECT SUBSTRING('2022_file/1e2e8y6hwbdo9t3n.pdf,云审批字[2021]45号',CHARINDEX(',','2022_file/1e2e8y6hwbdo9t3n.pdf,云审批字[2021]45号')+1,LEN('2022_file/1e2e8y6hwbdo9t3n.pdf,云审批字[2021]45号')) AS A
多个逗号,取最后的
SELECT REVERSE(SUBSTRING(REVERSE('2022_file/1e2e8y6hwbdo9t3n.pdf,SS,云审批字[2021]45号'),1,CHARINDEX(',',REVERSE('2022_file/1e2e8y6hwbdo9t3n.pdf,SS,云审批字[2021]45号'))-1))
![1653905376907353.png image.png](/upload/wenda/20220530/1653905376907353.png)