我有一个现有的json文件需要转换,但遇到了问题.
以下是该 struct 的一个示例:
jq -r '.document.results.summary.run.[] | [.run_number, .cinfo] ' input.json
[
"42",
[
{
"name": "Joe shmo",
"state": "AZ",
"city": "Phoenix"
},
{
"name": "Jane shmo",
"state": "CA",
"city": "Blythe"
]
]
[
"84",
[
{
"name": "Jake shmo",
"state": "NY",
"city": "Albany"
},
{
"name": "Jay shmo",
"state": "TN",
"city": "Franklin"
]
]
I need to convert this to a CSV to look like:
"run_number","cinfo.name","cinfo.state","cinfo.city"
Example:
"42","Joe shmo","AZ","Phoenix"
"42","Jane shmo","CA","Blythe"
"84","Jake shmo","NY","Albany"
"84","Jay shmo","TN","Franklin"
我try 使用|@csv我得到:
jq: error (at input.json:1397): array ([{"@name":"...) is not valid in a csv row
个
我相信这是因为它是由多个索引组成的array.如何使用JQ转换输出?