Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a field File Name like below. Please help me to remove .xlsx from File Name field.
File Name
ABM.xlsx
Approved - CDCP - IRD.xlsx
ABC Insight_Tagging v0.4 working.xlsx
Expected File Name
ABM
Approved - CDCP - IRD
ABC Insight_Tagging v0.4 working
Thanks in advance.
Hi
Try this
Replace(FileNAme,'.xlsx','')
Thanks
Hi
Try this
Replace(FileNAme,'.xlsx','')
Thanks
Mid(filename, 1, index(filename, '.', -1) -1)
-Rob