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:



      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!