2 Replies Latest reply: Oct 6, 2014 7:48 AM by Marco Wedel RSS

    How to load without fileextension using filename()

      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