Filtering and Formating JSON with JQ

jq_filter_formatting.md

Create test.json:

cat << 'EOF' > ./test.json
[
  {
    "name": "First1 Last",
    "email": "first1@company.io",
    "state": "A"
  },
  {
    "name": "First2 Last",
    "email": "first2@company.io",
    "state": "S"
  }
]
EOF

Filter on state=A, format output of name and email:

cat test.json | jq -r 'map(select(.state | contains ("A"))) | .[] | .name as $name | .email as $email | "Name: \($name), Email: \($email)"'

Output:

Name: First1 Last, Email: first1@company.io