topic Re: Get File Details in QlikView https://community.qlik.com/t5/QlikView/Get-File-Details/m-p/23102#M3859 <HTML><HEAD></HEAD><BODY><P>use filename()</P><P></P><P>mid(subfield(filename(),'_',2),1,8)</P><P></P><P>Regards</P></BODY></HTML> Wed, 14 Feb 2018 12:04:46 GMT PrashantSangle 2018-02-14T12:04:46Z Get File Details https://community.qlik.com/t5/QlikView/Get-File-Details/m-p/23101#M3858 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a file with the following naming convention :</P><P></P><P>DailyFileUpload_20171201011506.csv&nbsp; </P><P></P><P>Is it possible to extract the following into a temp table ::</P><P></P><P>DailyFileUpload as filename</P><P><SPAN style="font-size: 13.3333px;">20171201 as filenamedate</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">many thanks</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Phil<BR /></SPAN></P></BODY></HTML> Wed, 14 Feb 2018 11:58:01 GMT https://community.qlik.com/t5/QlikView/Get-File-Details/m-p/23101#M3858 prees959 2018-02-14T11:58:01Z Re: Get File Details https://community.qlik.com/t5/QlikView/Get-File-Details/m-p/23102#M3859 <HTML><HEAD></HEAD><BODY><P>use filename()</P><P></P><P>mid(subfield(filename(),'_',2),1,8)</P><P></P><P>Regards</P></BODY></HTML> Wed, 14 Feb 2018 12:04:46 GMT https://community.qlik.com/t5/QlikView/Get-File-Details/m-p/23102#M3859 PrashantSangle 2018-02-14T12:04:46Z Re: Get File Details https://community.qlik.com/t5/QlikView/Get-File-Details/m-p/23103#M3860 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>LOAD SubField(FileBaseName(), '_', 1) as filename,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; Date#(Left(SubField(FileBaseName(), '_', 2), 8), 'YYYYMMDD') as filenamedate</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; ...</STRONG></P><P><STRONG>From ....</STRONG></P></BODY></HTML> Wed, 14 Feb 2018 12:05:11 GMT https://community.qlik.com/t5/QlikView/Get-File-Details/m-p/23103#M3860 sunny_talwar 2018-02-14T12:05:11Z Re: Get File Details https://community.qlik.com/t5/QlikView/Get-File-Details/m-p/23104#M3861 <HTML><HEAD></HEAD><BODY><P>or left(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">subfield(filename(),'_',2),8</SPAN>)</P></BODY></HTML> Wed, 14 Feb 2018 12:05:45 GMT https://community.qlik.com/t5/QlikView/Get-File-Details/m-p/23104#M3861 PrashantSangle 2018-02-14T12:05:45Z