我有一个JSON对象,其中一个字段的值可以是字符串或数组。
{
"roles": ["ADMIN", "USER"]
"user_id": 100,
"message": "abc added a user xyz",
"level": "info",
"created_at": "2014-10-12 14:06:37"
}
{
"roles": "ADMIN"
"user_id": 102,
"message": "a added a user b",
"level": "info",
"created_at": "2014-10-12 14:06:37"
}
我想将“角色”字段转换为csv格式,同时保留其他字段不变。
{
"roles": "ADMIN,USER"
"user_id": 100,
"message": "abc added a user xyz",
"level": "info",
"created_at": "2014-10-12 14:06:37"
}
{
"roles": "ADMIN"
"user_id": 102,
"message": "a added a user b",
"level": "info",
"created_at": "2014-10-12 14:06:37"
}
我尝试阅读文档,但找不到一个仅转换单个字段的构造。使用Jq可以实现吗?
@csv
对于具有数组字段的对象失败了。所以这是必要的,让@csv
起作用。 - Sumit Jain@csv
时,我收到错误消息array(["ADMIN...])在CSV行中无效。传递给它的对象是
["2017-10-12T08:36:37.763Z", "info", 0, ["ADMIN], 1507797397763, 264074]`。 - Sumit Jain