10 Replies Latest reply: Nov 18, 2011 3:47 PM by Aissam Boumejjane RSS

    replacing a letter with a word

    Aissam Boumejjane

      Hi Guys,

       

      I want to replace a letter with a word in Qlikview, However when I use the replace statement, It replaces everything that has the letter "R".

       

      I first tried:

       

      Upper(Replace(shpg, 'R', 'Road)) That replaced all the words that have the letter "R".

       

      I then tried it with an if statement:

       

      if(shpg<>'R',

      Upper(replace(shpg, 'R', Road))

       

      That to didn't work.

       

      Basically I want to replace only the fields that have 'R' with Road.

       

      Hope u can help me!

       

      Thanks in advance!

       

      iSam