replace load script to replace some character with single quote '

[ronaldwang]

Since there is some data issue i need to use replace function in my load script to replace some special character to single quote. so ideally the function will look like replace(A,'B','C') which works fine but replace(A,'B',''') where i want to replace B with ' then there will be issue as i think Qlik confuse with ' and ''? any idea to solve the issue?

[MayilVahanan · Accepted solution]

Hi @ronaldwang 

Try like this

=replace(A,'B',Chr(39))

[rwunderlich]

Code two single quotes to represent quote as a literal. So in your case, 4 single quotes and it will work. 

replace(A,'B','''')

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[ronaldwang]

Both work perfectly, thank you