topic Re: How to take a substring of a string? in QlikView https://community.qlik.com/t5/QlikView/How-to-take-a-substring-of-a-string/m-p/103183#M602178 <HTML><HEAD></HEAD><BODY><P>You could use:</P><P></P><P>subfield('C:\Users\thom.yorke\Desktop\Samples\file1.doc', '\', -1) to get the filename with extension and another subfield() could also split them like:</P><P></P><P>subfield(subfield('C:\Users\thom.yorke\Desktop\Samples\file1.doc', '\', -1), '.', 1)</P><P></P><P>If it should happens within a load you could also use filebasename().</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 03 Aug 2018 14:32:30 GMT marcus_sommer 2018-08-03T14:32:30Z How to take a substring of a string? https://community.qlik.com/t5/QlikView/How-to-take-a-substring-of-a-string/m-p/103182#M602177 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>i want to obtain a substring (last part) of a string, because i've a path conteining a file name and i have to retrieve only the file name.</P><P></P><P>The work case is the following:</P><P>PATH: C:\Users\thom.yorke\Desktop\Samples\file1.doc</P><P>PATH FOLDER: <SPAN style="color: #575757; font-family: arial,helvetica,sans-serif; font-size: 13.33px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px;">C:\Users\thom.yorke\Desktop\Samples\</SPAN></P><P>NAME TO RETRIEVE: file1</P><P></P><P>Is there a method to subtract PATH FOLDER to string PATH?</P></BODY></HTML> Fri, 03 Aug 2018 09:26:48 GMT https://community.qlik.com/t5/QlikView/How-to-take-a-substring-of-a-string/m-p/103182#M602177 Anonymous 2018-08-03T09:26:48Z Re: How to take a substring of a string? https://community.qlik.com/t5/QlikView/How-to-take-a-substring-of-a-string/m-p/103183#M602178 <HTML><HEAD></HEAD><BODY><P>You could use:</P><P></P><P>subfield('C:\Users\thom.yorke\Desktop\Samples\file1.doc', '\', -1) to get the filename with extension and another subfield() could also split them like:</P><P></P><P>subfield(subfield('C:\Users\thom.yorke\Desktop\Samples\file1.doc', '\', -1), '.', 1)</P><P></P><P>If it should happens within a load you could also use filebasename().</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 03 Aug 2018 14:32:30 GMT https://community.qlik.com/t5/QlikView/How-to-take-a-substring-of-a-string/m-p/103183#M602178 marcus_sommer 2018-08-03T14:32:30Z Re: How to take a substring of a string? https://community.qlik.com/t5/QlikView/How-to-take-a-substring-of-a-string/m-p/103184#M602181 <HTML><HEAD></HEAD><BODY><P>Ok, it works fine!</P><P>Thank You a lot</P></BODY></HTML> Fri, 03 Aug 2018 14:36:56 GMT https://community.qlik.com/t5/QlikView/How-to-take-a-substring-of-a-string/m-p/103184#M602181 Anonymous 2018-08-03T14:36:56Z