topic Value of variable with single quote in QlikView

Value of variable with single quote

Mon, 30 Apr 2012 16:01:02 GMT

Hi all,

now my problem is that I need to put in the value of a variable a name, and this name contains a single quote (example: John D'Oe). How can I do this?

Thank you in advance

Carlo A. Babini

Value of variable with single quote

Mon, 30 Apr 2012 16:22:18 GMT

From the variable dialog, just enter as is.

From the load script the easiest way is to use set, e.g,

SET name=John D'Oe;

If you must use a LET stateement, use chr(39) function to create a single quote character, e.g.,

LET name='John D' & chr(39) & 'Oe';

Value of variable with single quote

Mon, 30 Apr 2012 16:22:53 GMT

Hi Carlo,

Try something like this after you define your variable - 'John D'&chr(39)&'Oe

Cheers

Value of variable with single quote

Mon, 30 Apr 2012 16:29:54 GMT

Ok, now I understand.

Thank you both