having ' (comma) in loading filter criteria?

[#1]

Hi all - new to qlik sense,

I have an if statement in my loading where I need to test field A being like 'd'anglo*' (and some similar). Is there a way to enable that so qlik don't take that for a text separator (which it does). I have tried putting double quotes around the comma and double single commas without success ('d"'"angelo' and 'd'''angelo')

Thanks

[rwunderlich]

you can use the chr(39) function to represent the single quote. A little clunky but it looks like this:

'd' & chr(39) & 'anglo*'

-Rob

http://masterssummit.com

http://robwunderlich.com

[ToniKautto]

You can use the Chr() fucntion to generate a character. The input value is the decimal index of the ASCII table. Single quote is equal to Chr(39).

T1:
LOAD 
  F1,
  If(F1 = 'd'&Chr(39)&'anglo', 1, 0) AS F2
Inline [
F1
d'anglo
];

[#4]

Thank you very much

works fine both ways 

If([SB Brand] Like 'Jacob'&chr(39)&'s*', 'Jacob'&chr(39)&'s Creek',

/A

[#5]

Thank you very much

works fine bothways

  If([SB Brand] Like 'Jacob'&chr(39)&'s*', 'Jacob'&chr(39)&'s Creek',

/A