LOAD list ';' separate like lines

[MarcoARaymundo]

Hi!

I have a field that the content is separated text. (1;2;3).

And now I need to transform this field in lines.

Field

1

2

3

Is it possible?

[Gysbert_Wassenaar · Accepted solution]

You can use the subfield function for this:

Load subfield(Field1, ';') as Field1;

Select Field1 from ...somewhere..,;

[MarcoARaymundo]

Thank you! but this is not what I need, see:

I have Field1 = 1;2;3 (select field1 from oracle)

I need "explode" field1 to..

Field1
1
2
3

I know there is a way to do this, but do not know how to do it.