6 Replies Latest reply on Sep 29, 2017 7:16 PM by Gianni Ceresa

    How to Identify and Replace the Last word in an address string ?

    Rohit Trehan

      Hi Users

       

      I have this unique String Manipulation issues at hand.

      Let me first paste the picture as pictures speak better than words:

       

      I have 2 issues at hand;

      1. Identify the LAST WORD in a given string - Done. "RD"

      2. Replace that word if it is "RD" then change it to "ROAD"; If it is "AVE" then change it to "AVENUE"

       

      I am looking for some guidance on the OBIEE command for that string manipulation.

       

      Thanks

      Rohit

       

       

      Start String

      Identify the Last Word

      Replace the Last word if it
        is "RD"

      Input String

      45 QUEEN EDWARD RD

      RD

      45 QUEEN EDWARD ROAD

      OBIEE Command

       

      RIGHT(REPLACE("Start String", ' ', REPEAT(' ', 100)),
        100)

       

       

      ?????