Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ...;