How do I remove all keys except one with jq?

2019-04-04 07:00发布

Given a list of objects, with many keys I don't want:

[{
    "name": "Alice",
    "group": "Admins",
    "created": "2014"
}, {
    "name": "Bob",
    "group": "Users",
    "created": "2014"
}]

How do I filter these objects to only include keys I want?

[{
    "name": "Alice"
}, {
    "name": "Bob"
}]

I've tried jq '.[].name' but that extracts the values, rather than preserving the objects.

4条回答
时光不老,我们不散
2楼-- · 2019-04-04 07:04

you can use map with del if you know the keys you don't want:

jq 'map(del (.group) | del (.created))'
查看更多
可以哭但决不认输i
3楼-- · 2019-04-04 07:09

Another solution without the map function:

jq '[.[] | {name: .name}]'
查看更多
我只想做你的唯一
4楼-- · 2019-04-04 07:13

The accepted answer (with map) and the equivalent answer by @mauricio-tranjano will, in effect, add the specified key to objects that don't already have it. If that's not the behavior you want, then consider using has(_), e.g.:

$ jq -c 'map( if has("a") then {a} else {} end )'

Input:

[{id:1,a:1}, {id:2}]

Output:

[{"a":1},{}]
查看更多
5楼-- · 2019-04-04 07:16

You can use the map() function to filter any key:

jq 'map({name: .name})'

Update

Suggested by @WilfredHughes: The above filter can be abbreviated as follows:

jq 'map({name})'
查看更多
登录 后发表回答