1 Reply Latest reply on Sep 6, 2016 11:47 PM by Mahfooj Khan

    Replace or REGEXP_Replace for wild card

    Love Walk'g

      I have different phases with similar structure within Column A,  that I would like to explore if a wild card replace or if REGexp_replace is avaiable to use.

       

      i don't not want to use individual replace as the list can get super long. I tried both and none of them working.

       

      Please see my attachment. "Column A finish" is my goal. Please suggest a effective function for wild card replacement.