Ch(39) produces double quotes instead of one

[Anonymous]

Hi I have an issue where iI'm using Chr(39) , however the result produces a double quote.

I have 2 variables. Hi I have an issue where iI'm using Chr(39) , however the result produces a double quote.

I have 2 variables.

let vQvd = 'QVD' & chr(39) & 's';

and

let vQvdlocation ='\\Intranet.barcapint.com\dfs-emea\GROUP\Jhb\TAT - Production\$(vQvd)\GLRS';

However the solution in the front end in a text box displays as follows:

Regards

Ntokozo

[Anonymous]

sorry,

below is the correct image of the QVD's output.

[rwunderlich]

Open the value in the expression editor and confirm if it's really a double quote or two single quotes. If two single quotes, it might be the parser trying to be helpful in escaping the quote. I've seen this in Sense but can't reproduce copying your example.  In any case, you should be able to work around the problem by using SET instead of LET.  It will simplify the first one also.

SET vQvd = "QVD's";

SET vQvdlocation =\\Intranet.barcapint.com\dfs-emea\GROUP\Jhb\TAT - Production\$(vQvd)\GLRS;

See for more info: LET, SET, Quotes | Qlikview Cookbook

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[marcus_sommer]

It looked like this one: Re: Ch(39) produces double quotes instead of one

- Marcus