1 Reply Latest reply on Oct 21, 2020 12:50 AM by Nico Heinze

    How replace exact word at given string in Power center

    RaviKumar Pentyala New Member

      Hi,

       

      I have a requirement wherein I need to delete the exact word from a given string. I have used REPALCESTR but it also removed from words where it's matching paritally. I don't want to replace it when the pattern matched to a part of the word.

       

      Here is an example:

       

      Source string:  "beta, SR, betaSR, RTM, GA"

      REplace string: SR

       

      Output: "beta, betaSR, RTM, GA"

       

      but REPLACESTR is giving the following output

       

       

      Output: "beta, beta, RTM, GA"