topic How to search for string. in QlikView

How to search for string.

Fri, 19 Sep 2014 13:55:07 GMT

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 — Fri, 19 Sep 2014 13:56:00 GMT

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 — Fri, 19 Sep 2014 14:19:48 GMT

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

Anonymous — Fri, 19 Sep 2014 14:38:03 GMT

why so complicated?

GetFolderPath() will returns folder path of your qvw file

ecolomer — Fri, 19 Sep 2014 15:10:32 GMT

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

or directly

GetFolderPath ()

MarcoWedel — Fri, 19 Sep 2014 22:00:17 GMT