7 Replies Latest reply: Jul 3, 2013 12:45 PM by orton607 RSS

    Computation to trim off the first part of the string within the list manager item values

    orton607

      Hello,

       

      Please help me with a computation after submit pl/sql function process to trim off the first part of the string (CQ..) within the list manager values. Support for example the list manager contains values such as

       

      CQ..SAMPLE1..TEST1

      CQ..SAMPLE2..TEST2

      CQ..SAMPLE1..TEST2

       

      The computation process should trim off the first part(CQ..) and should return the list manager values as

       

      SAMPLE1..TEST1

      SAMPLE2..TEST2

      SAMPLE1..TEST2

       

      Oracle APEX 4.0.2 is the version and Oracle 10g r2 is the database.

       

      Please help me with possible approaches in developing the function. Thanks in advance.

       

      Thanks,

      Orton