Subfield numerous spaces

[khaycock]

Is it possible in QlikView to use Subfield to separate data after a second delimiter? I want to separate out each line where there the word Missing starts? So where it says Missing CYBERARK Missing SCCM, I want them split up to two lines of data.

 

[marcus_sommer · Accepted solution]

You could try the following:

load *, 'Missing ' & subfield(replace(ControlStatus, 'Missing ', ''), ' ') as ControlStatus from Source;

- Marcus

[khaycock]

Yes this worked thank you!! How can I remove lines that have no data in ControlStatus? As now these just have the word Missing in them

[marcus_sommer]

Maybe with:

load *, 'Missing ' & subfield(replace(ControlStatus, 'Missing ', ''), ' ') as ControlStatus
from Source where len(trim(ControlStatus));

- Marcus

[khaycock]

You have made my day! Thanks so much 🙂