How to search for string.

[#1]

Hi

I am trying to get the name of document path of my QlikView document. The purpose is to store this path in a variable.

So for example my path is c:\MyFolder\MyDoc.qvw.

I want to get : c:\MyFolder\. This will make my document path.

Conventionally I would do some thing like

SUBFIELD('c:\MyFolder\MyDoc.qvw', '*.qvw', 1)

This is not working.

Which string function should I use?

Thanks

[MK_QSL]

What result you want ?

=SUBFIELD('c:\MyFolder\MyDoc.qvw', '.qvw', 1)

I think you want to store the Path dynamically...

Try below

=Left('c:\MyFolder\MyDoc.qvw',Index('c:\MyFolder\MyDoc.qvw','\',SubStringCount('c:\MyFolder\MyDoc.qvw','\')))

[MarcoWedel]

=Left(DocumentPath(),Len(DocumentPath())-Len(DocumentName()))

[Anonymous]

why so complicated?

GetFolderPath() will returns folder path of your qvw file

[ecolomer]

SUBFIELD('c:\MyFolder\MyDoc.qvw', '\', -1)

or directly

GetFolderPath ()

[MarcoWedel]

?