Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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)
A different solution could be
SET vSingleAndDoubleQuote = [aaa ' bbb " ccc];
Here you can read the explanation