Parent Child Relationship Field / Tree Structure Field

[Anonymous]

Hi guys

Has anyone worked with Parent/Child Structures like this
I want to remove Level 1-6 and have them in different fields for
selection for example on Level 2 (COOKE).

The delimiter is ‘ - ’

RANDFONTEIN-COOKE - COOKE - CONTROLLED NON SHAFT AREA - COOKE 3
- COOKE 3 OCCUPATIONAL HEALTH (CIRTECH ALARM) - COOKE 3 OCCUPATIONAL HEALTH
(CIRTECH ALARM)

Your assistance will be appreciated.

[swuehl]

What is your expected result?

You can split a single field into multiple fields using subfield:

LOAD

     Subfield(FIELD,'-',1) as Part1,

     Subfield(FIELD,'-',2) as Part2,

     Subfield(FIELD,'-',3) as Part3,

     Subfield(FIELD,'-',4) as Part4,

     Subfield(FIELD,'-',5) as Part5

FROM ...;