Extract repeated fields, where number of fields varies


(Chandrashekar V) #1

Hi All,

I have a html log that gets generated from some of our servers.

This is similar to below provided snippet. The key:value pairs for each operationName is


operationName1

key1

key1 related data here

key2

key2 related data here

key3

key3 related data here

key4

key4 related data here

operationName2

key1

key1 related data here

key2

key2 related data here

key3

key3 related data here

operationName3

key1

key1 related data here

key2

key2 related data here

key3

key3 related data here

key4

key4 related data here

key5

key5 related data here

key6

key6 related data here

operationName4

key1

key1 related data here

key2

key2 related data here

key3

key3 related data here

key4

key4 related data here

key5

key5 related data here

key6

key6 related data here

key7

key7 related data here

key8

key8 related data here

As we can see, number of keys are not fixed and varies for each operationName.

I am not sure as to which filter can be used to extract all values for a particular operationName.

I was expecting some thing similar to below:

{
"operationName1": [ { "key1": "key1value"},{ "key2":"key2value"},{"key3":"key3value"},{"key4":"key4value"}],
"operationName2": [ { "key1": "key1value"},{ "key2":"key2value"},{"key3":"key3value"}]
}

Please provide pointers.

Thanks
V.Chandrashekar


(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.