topic Re: Filename extension in QlikView https://community.qlik.com/t5/QlikView/Filename-extension/m-p/1085532#M922276 <HTML><HEAD></HEAD><BODY><P>Absolutely <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 22 Apr 2016 10:19:05 GMT sunny_talwar 2016-04-22T10:19:05Z Filename extension https://community.qlik.com/t5/QlikView/Filename-extension/m-p/1085529#M922273 <HTML><HEAD></HEAD><BODY><P>So I have a filename with the</P><P></P><P>Date_Area_Service.xlsx</P><P></P><P>Filenames would be like</P><P></P><P>032016_BR_Telecoms.xlsx</P><P>042015_BR_Networks.xlsx</P><P>052016_BR_ADS.xlsx</P><P>062015_BR_ServiceDesk.xlsx</P><P></P><P>Because the Service names vary in the number of characters, how do I get just the Service?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Filename-extension/m-p/1085529#M922273 bobbydave 2020-11-25T16:16:04Z Re: Filename extension https://community.qlik.com/t5/QlikView/Filename-extension/m-p/1085530#M922274 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>LOAD</STRONG></P><P><STRONG>SubField(FileBaseName(), '_', -1) as Service</STRONG></P><P></P><P>or</P><P></P><P style="font-size: 13.3333px;"><STRONG>LOAD</STRONG></P><P style="font-size: 13.3333px;"><STRONG>Replace(SubField(FileName(), '_', -1), '.xlsx', '') as Service</STRONG></P></BODY></HTML> Fri, 22 Apr 2016 10:16:00 GMT https://community.qlik.com/t5/QlikView/Filename-extension/m-p/1085530#M922274 sunny_talwar 2016-04-22T10:16:00Z Re: Filename extension https://community.qlik.com/t5/QlikView/Filename-extension/m-p/1085531#M922275 <HTML><HEAD></HEAD><BODY><P>Wow .... as simple as that.</P><P>Thanks</P></BODY></HTML> Fri, 22 Apr 2016 10:17:43 GMT https://community.qlik.com/t5/QlikView/Filename-extension/m-p/1085531#M922275 bobbydave 2016-04-22T10:17:43Z Re: Filename extension https://community.qlik.com/t5/QlikView/Filename-extension/m-p/1085532#M922276 <HTML><HEAD></HEAD><BODY><P>Absolutely <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 22 Apr 2016 10:19:05 GMT https://community.qlik.com/t5/QlikView/Filename-extension/m-p/1085532#M922276 sunny_talwar 2016-04-22T10:19:05Z