Splunk Search
Highlighted

How to extract a key value pair, convert it to a JSON format and assign it to a variable using eval?

Communicator

Hi Guys,

I have a log event like the following

2015-01-08T08:56:30.835Z "Name:John"="21","Name:Sam"="29","Name:Jim"="40"

.....(not just three)

How do I extract the Name and the corresponding number and convert it in to a JSON format like the one below.
{John:21,Sam:29,Jim:40}

I can extract the name and the number, but what I'm not sure about is how I can change it to the JSON format above.

NB: I need to assign this json formatted string to a variable using eval.
eval new_var=[search that generate the JSON formatted string]

0 Karma
Highlighted

Re: How to extract a key value pair, convert it to a JSON format and assign it to a variable using eval?

Splunk Employee
Splunk Employee

What exactly are you going to use new_var for because you can export extracted name and number fields directly from the UI as JSON?

A hacky way to convert the entire quoted string of names and numbers into JSON is to essentially extract it wholesale and apply several rex commands to shape it into the correct form:

Field test: "Name:John"="21","Name:Sam"="29","Name:Jim"="40"
Search: | rex field=test mode=sed "s/(\"Name:)|(\")//g" | rex field=test mode=sed "s/=/:/g" | rex field=test mode=sed "s/^/{/" | rex field=test mode=sed "s/$/}/g"

Full example:

| stats count | eval test="\"Name:John\"=\"21\",\"Name:Sam\"=\"29\",\"Name:Jim\"=\"40\"" | rex field=test  mode=sed "s/(\"Name:)|(\")//g" | rex field=test  mode=sed "s/=/:/g" | rex field=test  mode=sed "s/^/{/" | rex field=test  mode=sed "s/$/}/g"

Output:

{John:21,Sam:29,Jim:40} 

View solution in original post

Highlighted

Re: How to extract a key value pair, convert it to a JSON format and assign it to a variable using eval?

Communicator

I'm using a splunk app which has a variable that accepts some data in the form of a JSON object (eval appvariable=newvar). What I was trying to do is to convert the data in to a JSON format. Please let me know if you have a better way to do this.

0 Karma
Highlighted

Re: How to extract a key value pair, convert it to a JSON format and assign it to a variable using eval?

Communicator

Your solution solved my problem. But please do let know if you have a better way to get this done.

0 Karma