JQ - 如何将带标题的 CSV 转换为带嵌套字典的 JSON 数组

发布于 2025-01-10 01:14:22 字数 439 浏览 1 评论 0原文

我得到了以下 CSV 示例

key1,key2,key3,key4,key5
val1,val2,val3,val4,val5

寻找如何将上述结构转换为以下 JSON 结构的提示

[
{
"event": "bleep",
"sourcetype": "rats",
"fields":  {
"key1":"val1",
"key2":"val2",
"key3":"val3",
"key4":"val4",
"key5":"val5"
 }
},
{
"event": "bleep",
"sourcetype": "rats",
"fields":  {
"key1":"val1",
"key2":"val2",
"key3":"val3",
"key4":"val4",
"key5":"val5"
 }
}
]

提前致谢！

原文

I got the following CSV sample

key1,key2,key3,key4,key5
val1,val2,val3,val4,val5

Looking for tips how to convert the above structure into the following JSON structure

[
{
"event": "bleep",
"sourcetype": "rats",
"fields":  {
"key1":"val1",
"key2":"val2",
"key3":"val3",
"key4":"val4",
"key5":"val5"
 }
},
{
"event": "bleep",
"sourcetype": "rats",
"fields":  {
"key1":"val1",
"key2":"val2",
"key3":"val3",
"key4":"val4",
"key5":"val5"
 }
}
]

Thanks in advance!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

撕心裂肺的伤痛 2025-01-17 01:14:22

使用 -R 将输入读取为原始文本

jq -R '
  (. / ",") as $keys
  | [ inputs / "," | [$keys, .]
    | reduce transpose[] as $i (
        {event: "bleep", sourcetype: "rats"}; .fields[$i[0]] = $i[1])
      ]
' input.csv

演示

Use -R to read the input as raw text

jq -R '
  (. / ",") as $keys
  | [ inputs / "," | [$keys, .]
    | reduce transpose[] as $i (
        {event: "bleep", sourcetype: "rats"}; .fields[$i[0]] = $i[1])
      ]
' input.csv

Demo

回复收藏 0 原文

在巴黎塔顶看东京樱花 2025-01-17 01:14:22

Alasql lib 可以从服务器加载数据文件，解析它并将结果放入 JSON 对象数组。

所以，这是给你的一些例子：

<script src="alasql.min.js"></script>
<script>
        alasql('SELECT * FROM CSV("FileName.csv",{headers:true})',[],function(res){
        var dataResult = {items:res};
        });
</script>

Alasql lib can load the data file from server, parse it and put the result to array of JSON objects.

So, this is some example for you:

<script src="alasql.min.js"></script>
<script>
        alasql('SELECT * FROM CSV("FileName.csv",{headers:true})',[],function(res){
        var dataResult = {items:res};
        });
</script>

回复收藏 0 原文

~没有更多了~