10 Replies Latest reply: Jul 24, 2014 1:57 AM by venkata Sreekanth RSS

    Split string field into table rows

      Hi,

       

      I am facing the following problem.

       

      I have table A like this:

       

      ID    I     INVOICE

       

      1     I     S200/M250/R35/

      2     I     M1687/A35/D879/F689/

      3     I     B33625/S55/

       

      For each "ID", I need to split the "INVOICE" string field as shown below :

       

       

      ID    I     INVOICE

       

      1     I     S200

      1     I     M250

      1     I     R35

      2     I     M1687

      2     I     A35

      2     I     D879

      ..............................

      3     I     S55

       

       

      Any idea how to do it?

       

      Best regards.