topic Re: Check if exist Exit Script in .qvw in QlikView

Check if exist Exit Script in .qvw

aitor_torreno — Thu, 14 Jun 2018 11:18:39 GMT

Good morning everyone,

I need to take one or more .qwv and analyze in another QlikView file the code in search of knowing if it contains some Exit Script the Script of those documents and that show me a simple YES / NO, or any suggestion that you can have.

Thank you very much

Re: Check if exist Exit Script in .qvw

felipedl — Mon, 18 Jun 2018 11:01:24 GMT

Hi Aitor,

I was building a few applications for my own purposes, but can repurpose them for searching an exit script.

For checking the QVW scritp, it's best to extract the script into a text file and then checking for strings.

The attached compressed file has two folders:

Write Script to File: will extract the QVWs script to the folder you want.
Extract Text from Script: will check for exit script or whatever string you need and return YES if it finds the pattern you defined.

I've put and example with two QVWs to be checked, sample and sample2, having in sample2 an "EXIT SCRIPT".

The result is as follows:

Only sample2.qvw is shown, as it contains the pattern for exit script statement.

The documents have some brief descriptions on them if you need.

Hope it helps.

Re: Check if exist Exit Script in .qvw

aitor_torreno — Wed, 20 Jun 2018 08:15:31 GMT

Hi Felip,

I try to download the rar that you add but it say that is corrupted so I can't try the method that you say.

Re: Check if exist Exit Script in .qvw

felipedl — Wed, 20 Jun 2018 15:32:22 GMT

Hi Aitor,

Attached the .RAR files

Felipe.

Re: Check if exist Exit Script in .qvw

rwunderlich — Wed, 20 Jun 2018 22:35:01 GMT

You can use this utility to extract the script from a set of QVWs and search either through the UI search object or by providing a search words file.

Qlikview Cookbook: Script Repository http://qlikviewcookbook.com/recipes/download-info/script-repository/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com