This discussion is archived
6 Replies Latest reply: Aug 28, 2013 12:11 PM by djjao728 RSS

PLEASE HELP ME!!! SPLITTING COLUMNS IN ORACLE DISCOVERER

djjao728 Newbie
Currently Being Moderated

I have a certain column in Discoverer that I need to separate:

 

Column Has:

 

ID

ROI*231333

MHAD*29283893

MDDDEDD*21893838

 

What I need it to do is separate by the * no matter what:

 

Should Look Like This At The End:

 

ID                                       NEW COLUMN

ROI*231333                        231333

MHAD*29283893                 29283893

MDDDEDD*21893838          21893838

 

I don't know how to create this calculation, can someone please help me out?

 

Thank you in advance for all your help!

Legend

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