topic Document path without filename in QlikView

Document path without filename

Thu, 20 Aug 2015 07:27:11 GMT

Hi,

I am trying to create a Part in the Script, that I can use for all my qvw-files.

Therefore I created two variables for qvw-path and qvw-Name (and I Need them both!)

LET vDocName = DocumentName();
Let vDocPath = DocumentPath ();

The Problem is now, that vDocPath has already the filename in it.

How can I realise, that the DocumentPath is only the DirectoryPath without the Filename

Thanks in advance for you help.

Chris

sunny_talwar — Thu, 20 Aug 2015 07:34:24 GMT

As Suggested by :Alessandro

=Mid(DocumentPath(), 1, FindOneOf(DocumentPath(), '\', -1))

Peter_Cammaert — Thu, 20 Aug 2015 07:39:14 GMT

Skip the vDocPath part after the last backslash. DocumentPath() will always return a string with backslashes.

LET vDocPathNoFileName = left('$(vDocPath)', index('$(vDocPath)', '\', -1));

Thu, 20 Aug 2015 07:41:14 GMT

thanks alot to everybody. it worked.

d_koti24 — Thu, 20 Aug 2015 07:44:59 GMT

HI Christian,

May be this helps:

=mid(DocumentPath(),1,len(DocumentPath())-len(DocumentName())-1)

Regards,

maksimlopatkin — Fri, 16 Nov 2018 11:00:47 GMT

Hi,

try special variable 'QvWorkPath'