topic Extract Key/Value from Text-Field in QlikView

Extract Key/Value from Text-Field

Mon, 15 Mar 2010 09:52:40 GMT

Hi,

I got a problem, where i couldn't find a solution for:

I have a field like


<log Key1="Value1" Key2="Value2" Key3="Value3" />

The goal is a construct where I can work with the values and key's like all other fields. The number of Key's and name's aren't fix.

Thanks &

Greets

Christoph

Extract Key/Value from Text-Field

montubhardwaj — Mon, 15 Mar 2010 10:40:31 GMT

Hi,

Not sure whether this will be helpful but you can try Subfield function to get it.

For example

subfield

('Hello World',' ',1) will return Hello and

subfield('Hello World',' ',2) will return World.

It will Separate out the values when a space is found.

Thanks,

Dinesh Sharma

Extract Key/Value from Text-Field

Mon, 15 Mar 2010 11:05:19 GMT

Hi,

the problem is that i don't know how much key/value pairs in the text-field exist. So I can't use the index.
If only use the seperator, i got the problem that both key and value get into the same field. So i cant select a key and get the corresponding values.