topic HTML encode syntax in QlikView https://community.qlik.com/t5/QlikView/HTML-encode-syntax/m-p/457129#M568286 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I'm working with a system where I can read comments on transactionrows, the problem is that the SQL DB saves the comments i HTML-syntax where for example "Enter" = <SPAN style="font-size: 8pt;">" &amp;#10;' " <SPAN style="font-size: 10pt;">and Qlikview can't <SPAN class="hps">interpret that, it needs chr(10) to understand.</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN class="hps"></SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN class="hps">in other cases I've used text(fieldname) or num(fieldname) to force other datatypes, but it does'nt seem to exist any for decoding HTML-syntax!?</SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN class="hps"></SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN class="hps"></SPAN></SPAN><SPAN style="font-size: 10pt;"><SPAN class="hps">I</SPAN></SPAN><SPAN style="font-size: 10pt;"><SPAN class="hps">s it possible to encode fieldformats from HTML-syntax?</SPAN></SPAN></P><P></P></BODY></HTML> Fri, 26 Oct 2012 11:26:00 GMT atafsson 2012-10-26T11:26:00Z HTML encode syntax https://community.qlik.com/t5/QlikView/HTML-encode-syntax/m-p/457129#M568286 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I'm working with a system where I can read comments on transactionrows, the problem is that the SQL DB saves the comments i HTML-syntax where for example "Enter" = <SPAN style="font-size: 8pt;">" &amp;#10;' " <SPAN style="font-size: 10pt;">and Qlikview can't <SPAN class="hps">interpret that, it needs chr(10) to understand.</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN class="hps"></SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN class="hps">in other cases I've used text(fieldname) or num(fieldname) to force other datatypes, but it does'nt seem to exist any for decoding HTML-syntax!?</SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN class="hps"></SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN class="hps"></SPAN></SPAN><SPAN style="font-size: 10pt;"><SPAN class="hps">I</SPAN></SPAN><SPAN style="font-size: 10pt;"><SPAN class="hps">s it possible to encode fieldformats from HTML-syntax?</SPAN></SPAN></P><P></P></BODY></HTML> Fri, 26 Oct 2012 11:26:00 GMT https://community.qlik.com/t5/QlikView/HTML-encode-syntax/m-p/457129#M568286 atafsson 2012-10-26T11:26:00Z