4 Replies Latest reply on Oct 19, 2016 2:23 AM by curvette

    Getting a new table from text lines

    curvette

      Hi,

      this is my very big problem. I have a table with two fields:

       

      TABLE_A

      ID_AART_A
      100001-00002
      200003-00004-00005-00006-...
      300007-00008-00009

       

      But I need a table with data in this schema.

       

      TABLE_B

      ID_BART_B
      100001
      100002
      200003
      200004
      200005
      200006
      300007
      300008
      300009

       

      Is there anyone who can help me in compiling the script?

      Thank you