我有一个类似于下面的数据文件
{
"user01": {
"name": "User01 Name",
"age": "20",
"sex": "male",
"state": "CA",
"zip": "92012"
},
"user02": {
"name": "User02 Name",
"age": "22",
"sex": "female"
},
"user03": {
"age": "24",
"sex": "male",
"zip": "92412"
},
"user04": {
"name": "User05 Name",
"age": "30",
"sex": "female",
"state": "UT",
"zip": "96232"
}
}
我想得到这样的输出
"user01" "name" "User01 Name"
"user01" "age" "20"
"user01" "sex" "male"
"user01" "state" "CA"
"user01" "zip" "92012"
"user02" "name" "User02 Name"
"user02" "age" "22"
"user02" "sex" "female"
"user03" "age" "24"
"user03" "sex" "male"
"user03" "zip" "92412"
"user04" "name" "User05 Name"
"user04" "age" "30"
"user04" "sex" "female"
"user04" "state" "UT"
"user04" "zip" "96232"
我无法弄清楚如何保留顶级密钥,在处理每个密钥时打印密钥值对。感谢您的帮助。
jq -r '
to_entries[] | # replace items with {"key": ..., "value": ...}
.key as $username | # store top-level key in $username
.value | # later code operates only on value
to_entries[] | # break top-level value into key/value pairs
([$username, .key, .value] | # create list w/ desired output fields
map(tojson) | # encode those fields as literal JSON
join(" ")) # ...and separate those JSON fields with spaces
'
连接到单行上,如下所示:
jq -r 'to_entries[] | .key as $username | .value | to_entries[] | ([$username, .key, .value] | map(tojson) | join(" "))'
@peak https://stackoverflow.com/users/997358/peak还善意地指出了一个简洁的替代方案,避免了需要$username
:
jq -r '
to_entries[] | # Replace items with {"key":..., "value": ...}
[.key]+( # Prepend key to results of next group:
.value | # ...creating that group by starting with the value
to_entries[] | # ...then splitting it further into key/value pairs
[.key, .value] # ...then putting key and value into a list
) |
map(tojson) | # encode the results of the above as JSON strings
join(" ") # ...and then separate those strings with spaces.
'
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)