topic Re: Set a string variable that include both single code and double code in QlikView

Set a string variable that include both single code and double code

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I know that Qlikview can use both single code and a double code for a declaring a string. Bu what if I need to declare a string with both single and double code as part of the string.

For Example:

Following is the string:

I said "Don't go to there again!"

I need to define a string that store the whole line. What can I do?

Thanks !

Elim

Re: Set a string variable that include both single code and double code

kaushiknsolanki — Sun, 31 Jul 2016 07:09:47 GMT

Hi,

Try this code.

Way1:

Load * inline [

Data

I said "Don't go to there again!"

];

Way2:

Load '"I said '&'Don'&Chr(39)& 't go to There Again!"' as Field

AutoGenerate 1;

Regards,

Kaushik Solanki

Re: Set a string variable that include both single code and double code

vinieme12 — Sun, 31 Jul 2016 07:56:20 GMT

You would be using the ASCII codes for those literals

example

vString ='I said'&chr(34)&'Don'&chr(39)&'t go to there again!'&chr(34)

Re: Set a string variable that include both single code and double code

maxgro — Sun, 31 Jul 2016 08:16:34 GMT

A different solution could be

SET vSingleAndDoubleQuote = [aaa ' bbb " ccc];

Here you can read the explanation

Escape sequences