5 Replies Latest reply: Feb 19, 2016 7:50 AM by Xavier HEMELAAR RSS

    replace partialy field values

    Xavier HEMELAAR

      Hi Qlikers,

      I would like to know if there is a way to replace partialy some field values. Let say I have a column A that I load, but during load if the value is like '*test*' then "test" hase to be replaced by "OK".


      if (A like '*test*', ...'OK'... ) AS A



      So if value is " this is a test" I would like to have the following result: "this is a OK"

      Thanks for your help