且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用jq将JSON数组转换为CSV

更新时间:2023-01-17 18:53:55

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"