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.
Try SubField( filenname(),'.',1)
use filebasename() instead
Retrieving data ...