topic Trim pAth in QlikView https://community.qlik.com/t5/QlikView/Trim-pAth/m-p/528499#M197515 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P>pl guide me how i can remove <STRONG>ABC.qvw</STRONG> file from below mentioned path</P><P></P><P>Eg.</P><P><STRONG>\\abc0012\K$\Myfolder\App_name\ABC.qvw</STRONG></P><P></P><P>Im Looking something like<STRONG> \\abc0012\K$\Myfolder\App_name\</STRONG></P><P></P><P><STRONG>Note:path will be dynamic .</STRONG></P><P></P><P><STRONG>Thanks for any suugestion.</STRONG></P></BODY></HTML> Wed, 04 Dec 2013 15:11:05 GMT srinivasa1 2013-12-04T15:11:05Z Trim pAth https://community.qlik.com/t5/QlikView/Trim-pAth/m-p/528499#M197515 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P>pl guide me how i can remove <STRONG>ABC.qvw</STRONG> file from below mentioned path</P><P></P><P>Eg.</P><P><STRONG>\\abc0012\K$\Myfolder\App_name\ABC.qvw</STRONG></P><P></P><P>Im Looking something like<STRONG> \\abc0012\K$\Myfolder\App_name\</STRONG></P><P></P><P><STRONG>Note:path will be dynamic .</STRONG></P><P></P><P><STRONG>Thanks for any suugestion.</STRONG></P></BODY></HTML> Wed, 04 Dec 2013 15:11:05 GMT https://community.qlik.com/t5/QlikView/Trim-pAth/m-p/528499#M197515 srinivasa1 2013-12-04T15:11:05Z Re: Trim pAth https://community.qlik.com/t5/QlikView/Trim-pAth/m-p/528500#M197516 <HTML><HEAD></HEAD><BODY><P>left(MyPath, index(MyPath,'\',-1))</P><P></P><P>If you're working with files then you can use the filedir() function to retrieve the path of the directory that contains the file.</P></BODY></HTML> Wed, 04 Dec 2013 18:19:46 GMT https://community.qlik.com/t5/QlikView/Trim-pAth/m-p/528500#M197516 Gysbert_Wassenaar 2013-12-04T18:19:46Z