topic How to load without fileextension using filename() in QlikView https://community.qlik.com/t5/QlikView/How-to-load-without-fileextension-using-filename/m-p/664436#M668967 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I am trying to a file with name JAN_2014. Using filenname() I am trying creating column with JAN_2014 using filename() funtion.</P><P></P><P>But its creating a column with extension of file like JAN_2014.txt.</P><P></P><P>I dont want to get extensions into the created column.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 06 Oct 2014 11:17:00 GMT 2014-10-06T11:17:00Z How to load without fileextension using filename() https://community.qlik.com/t5/QlikView/How-to-load-without-fileextension-using-filename/m-p/664436#M668967 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I am trying to a file with name JAN_2014. Using filenname() I am trying creating column with JAN_2014 using filename() funtion.</P><P></P><P>But its creating a column with extension of file like JAN_2014.txt.</P><P></P><P>I dont want to get extensions into the created column.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 06 Oct 2014 11:17:00 GMT https://community.qlik.com/t5/QlikView/How-to-load-without-fileextension-using-filename/m-p/664436#M668967 2014-10-06T11:17:00Z Re: How to load without fileextension using filename() https://community.qlik.com/t5/QlikView/How-to-load-without-fileextension-using-filename/m-p/664437#M668968 <HTML><HEAD></HEAD><BODY><P>Try SubField(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> filenname(),'.',1)</SPAN></P></BODY></HTML> Mon, 06 Oct 2014 11:21:16 GMT https://community.qlik.com/t5/QlikView/How-to-load-without-fileextension-using-filename/m-p/664437#M668968 anbu1984 2014-10-06T11:21:16Z Re: How to load without fileextension using filename() https://community.qlik.com/t5/QlikView/How-to-load-without-fileextension-using-filename/m-p/664438#M668969 <HTML><HEAD></HEAD><BODY><P>use filebasename() instead</P></BODY></HTML> Mon, 06 Oct 2014 11:48:42 GMT https://community.qlik.com/t5/QlikView/How-to-load-without-fileextension-using-filename/m-p/664438#M668969 MarcoWedel 2014-10-06T11:48:42Z