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

    replace string


      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