5 Replies Latest reply: Aug 28, 2013 4:36 AM by Olivier Goossens Bara RSS

    replace string

      Hello

      In the ETL part, I'm getting string from a database

      Unfortunately some had the bad idea to encode diacritic as html in the database

      so in the sql select I'm doing such tricky thing to make replacement

       


      replace(replace(replace(replace(Replace(Replace(detdsc.discrepancyreason,'’',''''),'é','é'),'è','è'),''',''''),'ô','ô'),'ê','ê') as discrepancyreason,

       

      Is there some easiest way to do that in Qlikview ?

       

      Thanks for your help