topic script with ' in Water Cooler https://community.qlik.com/t5/Water-Cooler/script-with/m-p/589340#M2446 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i want to write in my script:</P><P></P><P>if(fieldname= 'abc'd' , 'a' , fieldname) as fieldname</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">' - its a part of the word....</SPAN></P><P></P><P>how can i do that?</P><P></P><P>tnx</P></BODY></HTML> Thu, 30 Jan 2014 14:48:37 GMT adiarnon 2014-01-30T14:48:37Z script with ' https://community.qlik.com/t5/Water-Cooler/script-with/m-p/589340#M2446 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i want to write in my script:</P><P></P><P>if(fieldname= 'abc'd' , 'a' , fieldname) as fieldname</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">' - its a part of the word....</SPAN></P><P></P><P>how can i do that?</P><P></P><P>tnx</P></BODY></HTML> Thu, 30 Jan 2014 14:48:37 GMT https://community.qlik.com/t5/Water-Cooler/script-with/m-p/589340#M2446 adiarnon 2014-01-30T14:48:37Z Re: script with ' https://community.qlik.com/t5/Water-Cooler/script-with/m-p/589341#M2447 <HTML><HEAD></HEAD><BODY><P>you could use CHR(39)</P></BODY></HTML> Thu, 30 Jan 2014 14:51:57 GMT https://community.qlik.com/t5/Water-Cooler/script-with/m-p/589341#M2447 rustyfishbones 2014-01-30T14:51:57Z Re: script with ' https://community.qlik.com/t5/Water-Cooler/script-with/m-p/589342#M2448 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">if(fieldname= =&nbsp; 'abc' &amp; chr(39) &amp; 'd', 'a' , fieldname) as fieldname</SPAN></P></BODY></HTML> Thu, 30 Jan 2014 14:52:14 GMT https://community.qlik.com/t5/Water-Cooler/script-with/m-p/589342#M2448 Anonymous 2014-01-30T14:52:14Z