Discussion Board for collaboration related to QlikView App Development.
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.
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?
Try this code.
Load * inline [
Load '"I said '&'Don'&Chr(39)& 't go to There Again!"' as Field
View solution in original post
You would be using the ASCII codes for those literals
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