left function help

[mahitham]

Hi,

Can any one  please help me to exclude .xlsx from the below field called Filename.

Filename

abcd.xlsx

abcdefghj.xlsx

abcdefghijk.xlsx

[kumarkp412 · Accepted solution]

Hi,

Use the subfeild function to get before .xlsx.

ex: subfeild(string,'.',1) as string

Thanks

kumar kvp