0 Replies Latest reply: Oct 26, 2012 7:26 AM by Axel Gustafsson RSS

    HTML encode syntax

    Axel Gustafsson

      Hi all,

      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" = " 
' " and Qlikview can't interpret that, it needs chr(10) to understand.

       

      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!?

       

      Is it possible to encode fieldformats from HTML-syntax?