topic Re: Finding out the file extension in QlikView https://community.qlik.com/t5/QlikView/Finding-out-the-file-extension/m-p/832505#M292898 <HTML><HEAD></HEAD><BODY><P>yes.</P><P>Use</P><P><STRONG>Subfield(filename(),'.',2) as FileExtension</STRONG></P><P>to get file extension.</P><P></P><P>example:</P><P>tab1:</P><P>Load <STRONG>Subfield(filename(),'.',2) as FileExtension</STRONG>,* </P><P>FROM excel or database</P><P>Regards,</P><P>Uday.</P></BODY></HTML> Mon, 11 May 2015 09:17:40 GMT 2015-05-11T09:17:40Z Finding out the file extension https://community.qlik.com/t5/QlikView/Finding-out-the-file-extension/m-p/832504#M292897 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Is it possible to find out the file extension of a file in the script?</P><P></P><P>Thanks,</P><P>Asma</P></BODY></HTML> Mon, 11 May 2015 09:10:19 GMT https://community.qlik.com/t5/QlikView/Finding-out-the-file-extension/m-p/832504#M292897 2015-05-11T09:10:19Z Re: Finding out the file extension https://community.qlik.com/t5/QlikView/Finding-out-the-file-extension/m-p/832505#M292898 <HTML><HEAD></HEAD><BODY><P>yes.</P><P>Use</P><P><STRONG>Subfield(filename(),'.',2) as FileExtension</STRONG></P><P>to get file extension.</P><P></P><P>example:</P><P>tab1:</P><P>Load <STRONG>Subfield(filename(),'.',2) as FileExtension</STRONG>,* </P><P>FROM excel or database</P><P>Regards,</P><P>Uday.</P></BODY></HTML> Mon, 11 May 2015 09:17:40 GMT https://community.qlik.com/t5/QlikView/Finding-out-the-file-extension/m-p/832505#M292898 2015-05-11T09:17:40Z Re: Finding out the file extension https://community.qlik.com/t5/QlikView/Finding-out-the-file-extension/m-p/832506#M292899 <HTML><HEAD></HEAD><BODY><P>Like this:</P><P></P><P class="Code">Load *, <STRONG>fileextension</STRONG>( ) as Ext</P><P class="Code">from .....\abc.txt</P></BODY></HTML> Mon, 11 May 2015 09:18:21 GMT https://community.qlik.com/t5/QlikView/Finding-out-the-file-extension/m-p/832506#M292899 tresB 2015-05-11T09:18:21Z