Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use filebasename() instead
Try SubField( filenname(),'.',1)
use filebasename() instead