Extract Key/Value from Text-Field

[#1]

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

[montubhardwaj]

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

[#3]

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.