Function help

[mahitham]

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.

[Kashyap_R · Accepted solution]

Hi

Try this

Replace(FileNAme,'.xlsx','')

Thanks

[rwunderlich]

Mid(filename, 1, index(filename, '.', -1) -1)

-Rob