6 Replies Latest reply: Aug 28, 2013 2:11 PM by djjao728 RSS

    PLEASE HELP ME!!! SPLITTING COLUMNS IN ORACLE DISCOVERER

    djjao728

      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!