Parse JSON data into a variable assignment format

Question

I am trying to parse JSON data into variable format

[
  {
    "Name" : "a",
    "Value" : "1"
  },
  {
    "Name" : "b",
    "Value" : "2"
  },
  {
    "Name" : "c",
    "Value" : "3"
  }
]

output should be like

a=1
b=2
c=3

This is what I tried, but it is not giving the expected result:

jq '.[].Value' file.txt

jq .[].Name file.txt or jq .[].Value file.txt this is printing key, valye in one go but how to assign value to key — Sandeep Sharma
– Sandeep Sharma, Commented May 2, 2016 at 12:50
cat file.txt |jq -r '.[].Name,.[].Value' I have tried this. Now how can I assign value to key in output? — Sandeep Sharma
– Sandeep Sharma, Commented May 2, 2016 at 13:22

Jeff Mercado · Accepted Answer · 2016-05-02 14:37:05Z

5

Since you're only printing out two values, it might just be easier to print out the strings directly.

$ jq -r '.[] | "\(.Name)=\(.Value)"' file.txt

answered May 2, 2016 at 14:37

Jeff Mercado

136k34 gold badges268 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

hek2mgl Over a year ago

Better than my attempt using a list and then join. I never knew that this kind if string interpolation is possible using jq.

glenn jackman Over a year ago

Also ... | .Name + "=" + .Value

hek2mgl · Accepted Answer · 2016-05-02 13:27:48Z

3

You can use the following jq command:

jq -r '.[]|[.Name,.Value]|join("=")' file.json

Output:

a=1
b=2
c=3

edited May 2, 2016 at 13:27

answered May 2, 2016 at 13:23

hek2mgl

159k31 gold badges263 silver badges280 bronze badges

2 Comments

bishop Over a year ago

This answer better represents the expected output, though my answer might be useful if the json format needs preservation through other modifications. Feel free to copy mine into your answer to provide an all-encompassing solution (then I'll delete mine).

hek2mgl Over a year ago

@bishop I see your point, but let me keep it simple. Readers will still have your answer as an alternative in such cases.

bishop · Accepted Answer · 2016-05-02 13:35:32Z

2

Using jq:

jq 'map({(.Name):.Value})|add|.//={}' < data.json

Produces:

{
  "a": "1",
  "b": "2",
  "c": "3"
}

If you have jq version 1.5+, you can use from_entries instead.

edited May 2, 2016 at 13:35

answered May 2, 2016 at 13:20

bishop

39.8k14 gold badges116 silver badges150 bronze badges

Comments

C14L · Accepted Answer · 2016-05-02 13:23:29Z

0

This does it

python3 -c 'import json; print("\n".join(["{}={}".format(x["Value"], x["Name"]) for x in json.load(open("file.json"))]))'

result

a=1
b=2
c=3

edited May 2, 2016 at 13:23

answered May 2, 2016 at 13:15

C14L

12.6k4 gold badges43 silver badges53 bronze badges

1 Comment

Jeff Mercado Over a year ago

A Python solution would not be adequate here, he was specifically looking for a jq solution.

Collectives™ on Stack Overflow

Parse JSON data into a variable assignment format

4 Answers 4

2 Comments

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related