使用jq将JSON数组转换为CSV [英] Convert JSON array into CSV using jq
本文介绍了使用jq将JSON数组转换为CSV的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个名为temp.json的JSON文件.
I have JSON file called temp.json.
{
"users": [
{
"username": "jack",
"email": "jack@somewhere.com",
"total running apps": "1",
"api-mock-app": "0",
"flogo": "1",
"ipaas": "0",
"nodejs-app": "0"
},
{
"username": "jill",
"email": "jill@somewhere.com",
"total running apps": "1",
"api-mock-app": "0",
"flogo": "1",
"ipaas": "0",
"nodejs-app": "0"
}
]
}
我想将此JSON转换为CSV,
i want to convert this JSON into CSV lilke this,
username email total running apps api-mock-app flogo ipaas nodejs-app
jack jack@somewhere.com 1 0 1 0 0
jill jill@somewhere.com 1 0 1 0 0
我尝试过
jq -r '.users[] | keys[0] [.username, .email, ."total running apps", ."api-mock-app", .flogo, .ipaas, ."nodejs-app"] | join(", ") | @csv' temp.json`
但是我遇到了错误
q: error (at temp.json:22): Cannot index string with string "jack"`
任何人都可以解释我在哪里犯错,请让我知道正确的答案.
Can anyone explain where am i making mistake and please let me know the correct answer.
推荐答案
jq 解决方案:
jq -r '(.users[0] | keys_unsorted), (.users[] | to_entries | map(.value))|@csv' temp.json
输出:
"username","email","total running apps","api-mock-app","flogo","ipaas","nodejs-app"
"jack","jack@somewhere.com","1","0","1","0","0"
"jill","jill@somewhere.com","1","0","1","0","0"
这篇关于使用jq将JSON数组转换为CSV的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文