1 Reply Latest reply: Feb 20, 2013 8:13 AM by Srini VEERAVALLI RSS

    How to use substring for below scenario in OBIEE

    947349
      Hi,

      In my prompt i have vlaue like below

      mumbai
      *004ABC -Total*
      *01111-Delhi - India*
      ABCDEF-Overseas


      its Code and name concatenated

      i just want only name to be displayed,here code and name separated by hyphen(-) ,
      but in my third record i have 2 hyphen and 2 names,so i need remove whichever there before first hyphen

      so my result should look like this

      mumbai
      Total
      Delhi - India
      Overseas

      can i know how to use substring and remove this


      Rgds
      SAB