topic Re: Subfield numerous spaces in QlikView

Subfield numerous spaces

khaycock — Sat, 16 Nov 2024 04:10:09 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_malinow — Thu, 14 Mar 2019 16:35:32 GMT

Hi,

if you just use

Subfield([Your field], ' ') as Newfield

without the index parameter this will split the data across several rows (depending on how many subfields exist in the source field.

Marcus

Re: Subfield numerous spaces

felipe87 — Tue, 21 May 2019 13:24:32 GMT

Great information! I really need this! I just went back to the help page and now I see it was there all the time.. But your explanation was more clearly and I think that should have an example of this on the help site.