Grep command from json file - Bash scripting

Question

My json file has the below content:

{
  "Fruits": {
    "counter": 1,
    "protocols": [
      {
        "id": "100",
        "name": "lemon",
        "category": "citrus"
      },
      {
        "id": "350",
        "name": "Orange",
        "category": "citrus"
      },
      {
        "id": "150",
        "name": "lime",
        "category": "citrus"
      }
    ]
  }
}

I am expecting an output as below

Fruits:lemon:citrus
Fruits:Orange:citrus
Fruits:lime:citrus

Don't use grep to process JSON. Use jq

Barmar
– Barmar

2020-05-08 23:49:59 +00:00
Commented May 8, 2020 at 23:49 — Barmar
– Barmar, Commented May 8, 2020 at 23:49

Shawn · Accepted Answer · 2020-05-09 00:02:08Z

5

Easy to do with jq:

$ jq -r '.Fruits.protocols[] | "Fruits:\(.name):\(.category)"' input.json
Fruits:lemon:citrus
Fruits:Orange:citrus
Fruits:lime:citrus

answered May 9, 2020 at 0:02

Shawn

53.9k3 gold badges29 silver badges74 bronze badges

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

5 Comments

Jetchisel Over a year ago

Nice!, I really like jq it becomes easy to parse json files using the shell.

apoonkun Over a year ago

Thank you. Unfortunately jq cannot be installed in my production environment. Is there any other alternative?

Philipp Claßen Over a year ago

@apoonkun What a pity, as the solution is very nice. If you have Ruby, you can try my answer. Maybe it helps you.

Shawn Over a year ago

@apoonkun You could use perl or python also, but, really, trying to do shell scripting that manipulates JSON without using jq is a Bad Idea.

Jetchisel Over a year ago

Even in git-bash you can install jq :-)

Philipp Claßen · Accepted Answer · 2020-05-09 00:14:51Z

The jq answer is better. Still posting a Ruby solution (if you cannot use jq), but it is less elegant:

ruby -e '
  require "json";
  l="";
  ARGF.each { |x| l+=x };
  obj=JSON.parse(l);
  obj["Fruits"]["protocols"].each { |x| puts "Fruits:#{x["name"]}:#{x["category"]}" }
'

Here is the full example:

echo '{"Fruits":{"counter":1,"protocols":[{"id":"100","name":"lemon","category":"citrus"},{"id":"350","name":"Orange","category":"citrus" },{"id":"150","name":"lime","category":"citrus"}]}}' \
| ruby -e 'require "json";l="";ARGF.each { |x| l+=x } ; obj=JSON.parse(l) ; obj["Fruits"]["protocols"].each { |x| puts "Fruits:#{x["name"]}:#{x["category"]}" }'

Output:

Fruits:lemon:citrus
Fruits:Orange:citrus
Fruits:lime:citrus

Collectives™ on Stack Overflow

Grep command from json file - Bash scripting

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related