AnsweredAssumed Answered

Getting a new table from text lines

Question asked by curvette on Oct 19, 2016
Latest reply on Oct 19, 2016 by 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

Outcomes