Trim pAth

[srinivasa1]

Hi

pl guide me how i can remove ABC.qvw file from below mentioned path

Eg.

\\abc0012\K$\Myfolder\App_name\ABC.qvw

Im Looking something like \\abc0012\K$\Myfolder\App_name\

Note:path will be dynamic .

Thanks for any suugestion.

[Gysbert_Wassenaar · Accepted solution]

left(MyPath, index(MyPath,'\',-1))

If you're working with files then you can use the filedir() function to retrieve the path of the directory that contains the file.