How to load without fileextension using filename()

[#1]

Hi Friends

I am trying to a file with name JAN_2014. Using filenname() I am trying creating column with JAN_2014 using filename() funtion.

But its creating a column with extension of file like JAN_2014.txt.

I dont want to get extensions into the created column.

Thanks

[anbu1984]

Try SubField( filenname(),'.',1)

[MarcoWedel · Accepted solution]

use filebasename() instead