topic Re: Subfield numerous spaces in QlikView

Subfield numerous spaces

khaycock — Sat, 16 Nov 2024 04:10:05 GMT

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.

Re: Subfield numerous spaces

marcus_sommer — Thu, 14 Mar 2019 15:58:20 GMT

You could try the following:

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

- Marcus

Re: Subfield numerous spaces

khaycock — Thu, 14 Mar 2019 16:03:03 GMT

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

Re: Subfield numerous spaces

marcus_sommer — Thu, 14 Mar 2019 16:16:37 GMT

Maybe with:

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

- Marcus

Re: Subfield numerous spaces

khaycock — Thu, 14 Mar 2019 16:19:35 GMT

You have made my day! Thanks so much 🙂