How can I subdivide a string like "level1 | level2 | level3" into 3 Datafields

[Anonymous]

Hi! I try to analyse our data from our ticketsystem. There is a field called section where users can choose the concerning topic of the ticket via a treeview. The database shows the 3 levels of this treeview as one string like 'level1 | level2 | level3'. How can I subdivide this string via script into three fields for each level? Thx!

[#2 · Accepted solution]

Hi,

You can Subfiled function.

eg:

subfield(S, ';' ,2)

returns 'cde' if S is 'abc;cde;efg'

[#3]

Try ths in your script.

Temp:

Load * Inline [

LinkValue,

level1 | level2 | level3

];

LinkSplit:

Load LinkValue,subfield(LinkValue,'|') as LinkSplit Resident Temp;

Drop table Temp;

Regards,

Kiran.

[Anonymous]

Thanks! Very helpful!