topic Re: Double quotes on Execute statement in QlikView

Double quotes on Execute statement

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'm trying to include in EXECUTE double quotes because i need it to perform a correct command in cmd:

I had it :

EXECUTE cmd.exe /C "Application.exe list=$(List) -logsOutput=logs/applog";

and it works perfectly, but if i insert in $(List) a String with space the Application.exe crashes.

I test it on cmd putting:

Application.exe list="String1;String 2; String String " -logsOutput=logs/applog

and it works too, but my problem now is that i don't be able to insert double quotes in EXECUTE statement:

EXECUTE cmd.exe /C "Application.exe list="$(List)" -logsOutput=logs/applog";

PS: I tried with chr(34) too and doesn't works.

Thanks in advance,

BR,

Ivan

Re: Double quotes on Execute statement

PrashantSangle — Thu, 14 Jul 2016 09:21:58 GMT

Hi,

In your variable definition add it.

Regards,

Re: Double quotes on Execute statement

Thu, 14 Jul 2016 09:29:36 GMT

Hi dreamer4‌,

I don't use a variable to do it, can you explain how i can do with it?

I try it putting all the string in a variable an then use EXECUTE Variable but it doesn't works..

Re: Double quotes on Execute statement

PrashantSangle — Thu, 14 Jul 2016 09:38:41 GMT

Hi,

How you assign value in List???

where you are creating List?

Regards

Re: Double quotes on Execute statement

Thu, 14 Jul 2016 10:33:54 GMT

Hi,

I did it removing cmd and quotes:

EXECUTE cmd.exe /C "Application.exe list=$(List) -logsOutput=logs/applog";

like this:

EXECUTE Application.exe list="$(List)" -logsOutput=logs/applog;

It works, thanks for the support!

BR,

Ivan.

Re: Double quotes on Execute statement

marcus_sommer — Thu, 14 Jul 2016 11:16:39 GMT

I think I would try something like this:

let vExecute = '"Application.exe list=' & '$(List)' & ' -logsOutput=logs/applog"';

EXECUTE cmd.exe /C $(vExecute);

- Marcus

Re: Double quotes on Execute statement

Peter_Cammaert — Thu, 14 Jul 2016 11:44:35 GMT

What about

EXECUTE cmd.exe /C Application.exe list="$(List)" -logsOutput=logs\applog;

Best,

Peter

Re: Double quotes on Execute statement

Peter_Cammaert — Thu, 14 Jul 2016 11:46:43 GMT

Or this?

EXECUTE cmd.exe /C "Application.exe list=""$(List)"" -logsOutput=logs\applog";

Best,

Peter

Re: Double quotes on Execute statement

PrashantSangle — Thu, 14 Jul 2016 12:31:55 GMT

Good

Close the thread.

Regards

Re: Double quotes on Execute statement

Thu, 14 Jul 2016 13:03:05 GMT

This works too.

Thanks guys!

Re: Double quotes on Execute statement

Peter_Cammaert — Thu, 14 Jul 2016 14:08:57 GMT

Keep in mind that those (double) quotes are processed by the cmd.exe command interpreter of Windows. AFAIK QlikView script will pass everything between the statement keyword EXECUTE and the terminating semicolon to the Exec/Fork call which will start an external shell. Only $-sign expansion will be applied by the script engine.

So actually the rules of the external command line processor will be applied here.

Best,

Peter