How can I grep JSON record with specific values in Linux

Question

Lets say I have this in the same file:

{
  "city": "NY",
  "car": "ford",
  "whatever": "whatever",
  "whatever": "whatever",
  "day": "friday",
  "mood": "good",
  "whatever": "whatever",
  "whatever": "whatever",
}
{
  "whatever": "whatever",
  "city": "NY",
  "car": "ford",
  "day": "monday",
  "whatever": "whatever",
  "whatever": "whatever",
  "whatever": "whatever",
  "mood": "good",
  "whatever": "whatever",
}

How can I grep only that record in which I have "day": "monday"? I've have actually tried a lot of different ways, for example grep -Po '{[^*]+\n.+day\": \"monday.+[^*]}' So eventually I want to get this:

{
  "whatever": "whatever",
  "city": "NY",
  "car": "ford",
  "day": "monday",
  "whatever": "whatever",
  "whatever": "whatever",
  "whatever": "whatever",
  "mood": "good",
  "whatever": "whatever",
}

Since it is JSON, you should consider using [JSON-specific tools](https://stackoverflow.com/questions/1955505/parsing-json-with-unix-tools). — Wiktor Stribiżew, Jun 14 '18 at 12:58
Stack Overflow is not a code writing service. Please show your code. — jww, Jun 14 '18 at 13:46
I've have actually tried a lot of different ways, for example `grep -Po '{[^*]+\n.+day\": \"monday.+[^*]}'` — Viacheslav On, Jun 14 '18 at 14:23

score 0 · Accepted Answer · answered Jun 14 '18 at 15:11

Try to use jq to parse the JSON file, for example having this file:

[{
    "city": "NY",
    "car": "ford",
    "whatever": "whatever",
    "day": "friday",
    "mood": "good"
}, {
    "whatever": "whatever",
    "city": "NY",
    "car": "ford",
    "day": "monday",
    "mood": "good"
}]

If you just want to get the dictionary having the day equal to monday:

jq '.[] |  select(.day | contains("monday"))' file.json

It will return:

{
  "whatever": "whatever",
  "city": "NY",
  "car": "ford",
  "day": "monday",
  "mood": "good"
}

This is the appropriate tool for the job. manual: https://stedolan.github.io/jq/manual/ — Erik Lievaart, Jun 14 '18 at 15:35

How can I grep JSON record with specific values in Linux

1 Answers1