我需要將 json 檔案映射并轉換為 csv。
這是我的檔案。請記住，它不是陣列。每個元素都在一行中。
{
"resourceType":"PractitionerRole",
"id":"2261026",
"meta":{
"versionId":"1",
"lastUpdated":"2021-11-08T15:13:39.318 01:00",
"source":"#wcktDPNPRW67Ths4"
},
"identifier":[
{
"system":"urn:oid:2.16.724.4.9.20.93",
"value":"6209"
},
{
"system":"urn:oid:2.16.724.4.9.20.2",
"value":"00042"
},
{
"system":"urn:oid:2.16.724.4.9.20.90",
"value":"UAB2"
}
],
"active":true,
"practitioner":{
"reference":"Practitioner/1046220"
},
"code":[
{
"coding":[
{
"system":"http://catsalut.gencat.cat/fhir/StructureDefinition/tipus-rol-professional",
"code":"MG"
}
]
}
]
}
{
"resourceType":"PractitionerRole",
"id":"2261027",
"meta":{
"versionId":"1",
"lastUpdated":"2021-11-08T15:13:39.140 01:00",
"source":"#l6DwTkxasiJQmfBJ"
},
"identifier":[
{
"system":"urn:oid:2.16.724.4.9.20.93",
"value":"6734"
},
{
"system":"urn:oid:2.16.724.4.9.20.2",
"value":"01785"
},
{
"system":"urn:oid:2.16.724.4.9.20.91",
"value":"IN013"
}
],
"active":true,
"practitioner":{
"reference":"Practitioner/1045804"
},
"code":[
{
"coding":[
{
"system":"http://catsalut.gencat.cat/fhir/StructureDefinition/tipus-rol-professional",
"code":"INF"
}
]
}
]
}
我需要獲取這些欄位：
.id, .meta.lastUpdated, .identifier[0].value, .identifier[1].value, .identifier[2].value, .code[0].coding[0].code
并id, lastUpdated, identifier1, identifier2, identifier3, code以 csv 格式提取它們。
有任何想法嗎？
uj5u.com熱心網友回復：
可以構造一個陣列，然后@csv直接使用：
$ jq -r '[.id,.meta.lastUpdated,.identifier[0].value,.identifier[1].value,.identifier[2].value,.code[0].coding[0].code] | @csv' file.txt
"2261026","2021-11-08T15:13:39.318 01:00","6209","00042","UAB2","MG"
"2261027","2021-11-08T15:13:39.140 01:00","6734","01785","IN013","INF"
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/361638.html
上一篇：JQ在過濾器前添加（靜態）標頭
下一篇：Rust反序列化JSON