topic Re: Capitalize in QlikView https://community.qlik.com/t5/QlikView/Capitalize/m-p/456142#M1153108 <HTML><HEAD></HEAD><BODY><P>Thank you.</P></BODY></HTML> Tue, 16 Apr 2013 22:45:57 GMT Anonymous 2013-04-16T22:45:57Z Capitalize https://community.qlik.com/t5/QlikView/Capitalize/m-p/456140#M1153106 <HTML><HEAD></HEAD><BODY><P>I'm using Capitalize(), it works fine for normal text but if there's a value like: </P><P>adam's </P><P>it converts it to:</P><P>Adam'S </P><P>I want: </P><P>Adam's</P><P></P><P>Any suggestions?</P></BODY></HTML> Mon, 15 Apr 2013 21:44:00 GMT https://community.qlik.com/t5/QlikView/Capitalize/m-p/456140#M1153106 Anonymous 2013-04-15T21:44:00Z Re: Capitalize https://community.qlik.com/t5/QlikView/Capitalize/m-p/456141#M1153107 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Try with this:</P><P></P><P>=Replace(Capitalize(Replace(<EM><STRONG>field</STRONG></EM>, chr(39), '_')), '_', chr(39))</P><P></P><P>Regards,</P><P>Ricardo</P></BODY></HTML> Mon, 15 Apr 2013 22:08:20 GMT https://community.qlik.com/t5/QlikView/Capitalize/m-p/456141#M1153107 2013-04-15T22:08:20Z Re: Capitalize https://community.qlik.com/t5/QlikView/Capitalize/m-p/456142#M1153108 <HTML><HEAD></HEAD><BODY><P>Thank you.</P></BODY></HTML> Tue, 16 Apr 2013 22:45:57 GMT https://community.qlik.com/t5/QlikView/Capitalize/m-p/456142#M1153108 Anonymous 2013-04-16T22:45:57Z