This discussion is archived
1 Reply Latest reply: Feb 20, 2013 6:13 AM by Srini VEERAVALLI RSS

How to use substring for below scenario in OBIEE

947349 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points