使用jq将仅具有值的json数组转换为csv [英] Convert json array with values only to csv using jq
本文介绍了使用jq将仅具有值的json数组转换为csv的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个下面的JSON,我需要将其转换为CSV.我遇到的问题是这些值没有键.
I have a below JSON and I need to convert it to a CSV. The problem I'm having is that those values have no key.
理想情况下,我希望CSV看起来像这样,我只是不知道如何使用jq.
Ideally I would like CSV to look like this, I just don't know how to do it using jq.
CSV
year;points;surname;name;point1;points2;points3;city;district;url
2020;54;Smith;John;;;London;Waterloo;URL
2015;380;Helen;Smith;;;New York;Manhattan;URL
JSON
{
"draw": 0,
"total": "44",
"filtered": "8",
"data": [
[
"2020",
"54",
"Smith ",
"John",
"",
"",
"",
"London",
"Waterloo",
"URL"
],
[
"2015",
"380",
"Helen ",
"Smith",
"",
"",
"",
"New York",
"Manhattan",
"URL"
]
],
"District": []
}
推荐答案
在示例中,.data []是平面数组流,因此要生成数据的CSV行,您可以:
In the sample, .data[] is a stream of flat arrays, so to produce the CSV rows for the data, you could:
.data[] | @csv
这篇关于使用jq将仅具有值的json数组转换为csv的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文