"Expand" field in several records

[salto]

Hello,

In the load script, from a table like this;

Topic_ID	1Header 2
1	#Blue; #Green
2	#White
3	#Red; #Green; #White

I need to build a table like this:

Topic ID	Keyword
1	Blue
1	Green
2	White
3	Red
3	Green
3	White

How can this be achieved? Many thanks in advance!

[jerem1234]

try something like:

purgechar(trim(subfield([1Header 2], ';')), '#')

Hope this helps!

[jerem1234 · Accepted solution]

Find attached.

[salto]

Just perfect... thank you!