Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Find attached.
try something like:
purgechar(trim(subfield([1Header 2], ';')), '#')
Hope this helps!
Find attached.
Just perfect... thank you!