Json
從 JSON 字元串中提取數據
我必須提取一個車牌數字，它與 JSON 字元串相關的可信度如下所示：
{ "response": { "container": { "id": "0df307bc-06b2-45cf-b7ff-ce07fd04e04d", "timestamp": "2018-Jul-10 17:34:27.448632" }, "id": "00000002-0000-0000-0000-000000000015" }, "frames": { "frame": { "id": "5583", "timestamp": "2016-Nov-30 13:05:27", "lps": { "lp": { "licenseplate": "15451BBL", "text": "15451BBL", "wtext": "15451BBL", "confidence": "20", "bkcolor": "16777215", "color": "16777215", "type": "0", "ntip": "11", "cct_country_short": "", "cct_state_short": "", "tips": { "tip": { "poly": { "p": { "x": "1094", "y": "643" }, "p": { "x": "1099", "y": "643" }, "p": { "x": "1099", "y": "667" }, "p": { "x": "1094", "y": "667" } }, "bkcolor": "16777215", "color": "0", "code": "49", "code_ascii": "1", "confidence": "97" }, "tip": { "poly": { "p": { "x": "1103", "y": "642" }, "p": { "x": "1113", "y": "642" }, "p": { "x": "1112", "y": "667" }, "p": { "x": "1102", "y": "667" } }, "bkcolor": "16777215", "color": "0", "code": "53", "code_ascii": "5", "confidence": "89" }, "tip": { "poly": { "p": { "x": "1112", "y": "640" }, "p": { "x": "1122", "y": "640" }, "p": { "x": "1122", "y": "666" }, "p": { "x": "1112", "y": "666" } }, "bkcolor": "16777215", "color": "0", "code": "52", "code_ascii": "4", "confidence": "97" }, "tip": { "poly": { "p": { "x": "1123", "y": "640" }, "p": { "x": "1132", "y": "640" }, "p": { "x": "1131", "y": "665" }, "p": { "x": "1123", "y": "665" } }, "bkcolor": "16777215", "color": "0", "code": "53", "code_ascii": "5", "confidence": "97" }, "tip": { "poly": { "p": { "x": "1134", "y": "640" }, "p": { "x": "1139", "y": "640" }, "p": { "x": "1139", "y": "664" }, "p": { "x": "1133", "y": "664" } }, "bkcolor": "16777215", "color": "0", "code": "49", "code_ascii": "1", "confidence": "77" }, "tip": { "poly": { "p": { "x": "1154", "y": "639" }, "p": { "x": "1163", "y": "639" }, "p": { "x": "1163", "y": "663" }, "p": { "x": "1153", "y": "663" } }, "bkcolor": "16777215", "color": "0", "code": "66", "code_ascii": "B", "confidence": "97" }, "tip": { "poly": { "p": { "x": "1164", "y": "638" }, "p": { "x": "1173", "y": "638" }, "p": { "x": "1173", "y": "663" }, "p": { "x": "1163", "y": "663" } }, "bkcolor": "16777215", "color": "0", "code": "66", "code_ascii": "B", "confidence": "94" }, "tip": { "poly": { "p": { "x": "1191", "y": "637" }, "p": { "x": "1206", "y": "636" }, "p": { "x": "1205", "y": "660" }, "p": { "x": "1190", "y": "661" } }, "bkcolor": "16777215", "color": "0", "code": "76", "code_ascii": "L", "confidence": "34" }, "tip": { "poly": { "p": { "x": "1103", "y": "655" }, "p": { "x": "1111", "y": "655" }, "p": { "x": "1111", "y": "667" }, "p": { "x": "1103", "y": "667" } }, "bkcolor": "16777215", "color": "0", "code": "74", "code_ascii": "J", "confidence": "57" }, "tip": { "poly": { "p": { "x": "1103", "y": "655" }, "p": { "x": "1111", "y": "655" }, "p": { "x": "1111", "y": "667" }, "p": { "x": "1103", "y": "667" } }, "bkcolor": "16777215", "color": "0", "code": "74", "code_ascii": "J", "confidence": "57" }, "tip": { "poly": { "p": { "x": "1176", "y": "638" }, "p": { "x": "1185", "y": "637" }, "p": { "x": "1184", "y": "661" }, "p": { "x": "1175", "y": "662" } }, "bkcolor": "16777215", "color": "0", "code": "52", "code_ascii": "4", "confidence": "7" } }, "ncharacter": "8", "characters": { "characater": { "poly": { "p": { "x": "1094", "y": "643" }, "p": { "x": "1099", "y": "643" }, "p": { "x": "1099", "y": "667" }, "p": { "x": "1094", "y": "667" } }, "bkcolor": "16777215", "color": "0", "code": "49", "code_ascii": "1", "confidence": "97" }, "characater": { "poly": { "p": { "x": "1103", "y": "642" }, "p": { "x": "1113", "y": "642" }, "p": { "x": "1112", "y": "667" }, "p": { "x": "1102", "y": "667" } }, "bkcolor": "16777215", "color": "0", "code": "53", "code_ascii": "5", "confidence": "89" }, "characater": { "poly": { "p": { "x": "1112", "y": "640" }, "p": { "x": "1122", "y": "640" }, "p": { "x": "1122", "y": "666" }, "p": { "x": "1112", "y": "666" } }, "bkcolor": "16777215", "color": "0", "code": "52", "code_ascii": "4", "confidence": "97" }, "characater": { "poly": { "p": { "x": "1123", "y": "640" }, "p": { "x": "1132", "y": "640" }, "p": { "x": "1131", "y": "665" }, "p": { "x": "1123", "y": "665" } }, "bkcolor": "16777215", "color": "0", "code": "53", "code_ascii": "5", "confidence": "97" }, "characater": { "poly": { "p": { "x": "1134", "y": "640" }, "p": { "x": "1139", "y": "640" }, "p": { "x": "1139", "y": "664" }, "p": { "x": "1133", "y": "664" } }, "bkcolor": "16777215", "color": "0", "code": "49", "code_ascii": "1", "confidence": "77" }, "characater": { "poly": { "p": { "x": "1154", "y": "639" }, "p": { "x": "1163", "y": "639" }, "p": { "x": "1163", "y": "663" }, "p": { "x": "1153", "y": "663" } }, "bkcolor": "16777215", "color": "0", "code": "66", "code_ascii": "B", "confidence": "97" }, "characater": { "poly": { "p": { "x": "1164", "y": "638" }, "p": { "x": "1173", "y": "638" }, "p": { "x": "1173", "y": "663" }, "p": { "x": "1163", "y": "663" } }, "bkcolor": "16777215", "color": "0", "code": "66", "code_ascii": "B", "confidence": "94" }, "characater": { "poly": { "p": { "x": "1191", "y": "637" }, "p": { "x": "1206", "y": "636" }, "p": { "x": "1205", "y": "660" }, "p": { "x": "1190", "y": "661" } }, "bkcolor": "16777215", "color": "0", "code": "76", "code_ascii": "L", "confidence": "34" } }, "det_time_us": "1104009", "poly": { "p": { "x": "1088", "y": "642" }, "p": { "x": "1210", "y": "634" }, "p": { "x": "1210", "y": "661" }, "p": { "x": "1087", "y": "669" } } } }, "det_time_us": "1710270" } } }我有類似的東西：
$ jq -r '.frames.frame.lps.lp|.characters.characater.code_ascii,.characters.characater.confidence' test.json但它只返回一個字母 & 它是 conf. 分數….
問題
- 如何取回所有字母和相關分數？
輸出
我希望輸出如下：
1 97, 5 89, 4 97,5 97, 1 77,B 97, B 94, L 34, J, 57,J 57, 4 7, 1 97, 5 89, 4 97, 5 97, 1 77, B 97, B 94, L 34**注意：**格式可以不同，這只是表示我要提取的數據。
複製粘貼
輸入文件“test.json”
{"response":{"container":{"id":"41d6efcb-24d6-490d-8880-762255519b5f","timestamp":"2018-Jul-11 19:51:06.461665"},"id":"00000002-0000-0000-0000-000000000015"},"frames":{"frame":{"id":"5583","timestamp":"2016-Nov-30 13:05:27","lps":{"lp":{"licenseplate":"15451BBL","text":"15451BBL","wtext":"15451BBL","confidence":"20","bkcolor":"16777215","color":"16777215","type":"0","ntip":"11","cct_country_short":"","cct_state_short":"","tips":{"tip":{"poly":{"p":{"x":"1094","y":"643"},"p":{"x":"1099","y":"643"},"p":{"x":"1099","y":"667"},"p":{"x":"1094","y":"667"}},"bkcolor":"16777215","color":"0","code":"49","code_ascii":"1","confidence":"97"},"tip":{"poly":{"p":{"x":"1103","y":"642"},"p":{"x":"1113","y":"642"},"p":{"x":"1112","y":"667"},"p":{"x":"1102","y":"667"}},"bkcolor":"16777215","color":"0","code":"53","code_ascii":"5","confidence":"89"},"tip":{"poly":{"p":{"x":"1112","y":"640"},"p":{"x":"1122","y":"640"},"p":{"x":"1122","y":"666"},"p":{"x":"1112","y":"666"}},"bkcolor":"16777215","color":"0","code":"52","code_ascii":"4","confidence":"97"},"tip":{"poly":{"p":{"x":"1123","y":"640"},"p":{"x":"1132","y":"640"},"p":{"x":"1131","y":"665"},"p":{"x":"1123","y":"665"}},"bkcolor":"16777215","color":"0","code":"53","code_ascii":"5","confidence":"97"},"tip":{"poly":{"p":{"x":"1134","y":"640"},"p":{"x":"1139","y":"640"},"p":{"x":"1139","y":"664"},"p":{"x":"1133","y":"664"}},"bkcolor":"16777215","color":"0","code":"49","code_ascii":"1","confidence":"77"},"tip":{"poly":{"p":{"x":"1154","y":"639"},"p":{"x":"1163","y":"639"},"p":{"x":"1163","y":"663"},"p":{"x":"1153","y":"663"}},"bkcolor":"16777215","color":"0","code":"66","code_ascii":"B","confidence":"97"},"tip":{"poly":{"p":{"x":"1164","y":"638"},"p":{"x":"1173","y":"638"},"p":{"x":"1173","y":"663"},"p":{"x":"1163","y":"663"}},"bkcolor":"16777215","color":"0","code":"66","code_ascii":"B","confidence":"94"},"tip":{"poly":{"p":{"x":"1191","y":"637"},"p":{"x":"1206","y":"636"},"p":{"x":"1205","y":"660"},"p":{"x":"1190","y":"661"}},"bkcolor":"16777215","color":"0","code":"76","code_ascii":"L","confidence":"34"},"tip":{"poly":{"p":{"x":"1103","y":"655"},"p":{"x":"1111","y":"655"},"p":{"x":"1111","y":"667"},"p":{"x":"1103","y":"667"}},"bkcolor":"16777215","color":"0","code":"74","code_ascii":"J","confidence":"57"},"tip":{"poly":{"p":{"x":"1103","y":"655"},"p":{"x":"1111","y":"655"},"p":{"x":"1111","y":"667"},"p":{"x":"1103","y":"667"}},"bkcolor":"16777215","color":"0","code":"74","code_ascii":"J","confidence":"57"},"tip":{"poly":{"p":{"x":"1176","y":"638"},"p":{"x":"1185","y":"637"},"p":{"x":"1184","y":"661"},"p":{"x":"1175","y":"662"}},"bkcolor":"16777215","color":"0","code":"52","code_ascii":"4","confidence":"7"}},"ncharacter":"8","characters":{"characater":{"poly":{"p":{"x":"1094","y":"643"},"p":{"x":"1099","y":"643"},"p":{"x":"1099","y":"667"},"p":{"x":"1094","y":"667"}},"bkcolor":"16777215","color":"0","code":"49","code_ascii":"1","confidence":"97"},"characater":{"poly":{"p":{"x":"1103","y":"642"},"p":{"x":"1113","y":"642"},"p":{"x":"1112","y":"667"},"p":{"x":"1102","y":"667"}},"bkcolor":"16777215","color":"0","code":"53","code_ascii":"5","confidence":"89"},"characater":{"poly":{"p":{"x":"1112","y":"640"},"p":{"x":"1122","y":"640"},"p":{"x":"1122","y":"666"},"p":{"x":"1112","y":"666"}},"bkcolor":"16777215","color":"0","code":"52","code_ascii":"4","confidence":"97"},"characater":{"poly":{"p":{"x":"1123","y":"640"},"p":{"x":"1132","y":"640"},"p":{"x":"1131","y":"665"},"p":{"x":"1123","y":"665"}},"bkcolor":"16777215","color":"0","code":"53","code_ascii":"5","confidence":"97"},"characater":{"poly":{"p":{"x":"1134","y":"640"},"p":{"x":"1139","y":"640"},"p":{"x":"1139","y":"664"},"p":{"x":"1133","y":"664"}},"bkcolor":"16777215","color":"0","code":"49","code_ascii":"1","confidence":"77"},"characater":{"poly":{"p":{"x":"1154","y":"639"},"p":{"x":"1163","y":"639"},"p":{"x":"1163","y":"663"},"p":{"x":"1153","y":"663"}},"bkcolor":"16777215","color":"0","code":"66","code_ascii":"B","confidence":"97"},"characater":{"poly":{"p":{"x":"1164","y":"638"},"p":{"x":"1173","y":"638"},"p":{"x":"1173","y":"663"},"p":{"x":"1163","y":"663"}},"bkcolor":"16777215","color":"0","code":"66","code_ascii":"B","confidence":"94"},"characater":{"poly":{"p":{"x":"1191","y":"637"},"p":{"x":"1206","y":"636"},"p":{"x":"1205","y":"660"},"p":{"x":"1190","y":"661"}},"bkcolor":"16777215","color":"0","code":"76","code_ascii":"L","confidence":"34"}},"det_time_us":"1072592","poly":{"p":{"x":"1088","y":"642"},"p":{"x":"1210","y":"634"},"p":{"x":"1210","y":"661"},"p":{"x":"1087","y":"669"}}}},"det_time_us":"1720812"}}}關聯
輸入文件：https ://drive.google.com/file/d/18wCzjMBpw7SIeVFByAGPQiqCBjg_0te3/view?usp=sharing
由於您的
characters數組不是正確的 JSON 數組（它是每個鍵具有相同名稱的散列），因此只有它的最後一個值可用。我們可以通過預處理數據來為現在呼叫的每個對象創建唯一鍵來解決這個問題
characater：awk '/"characater"/ { sub("\"characater\"", "\"char" ++n "\"", $0) } 1' file.json這將用
characater等char1替換每個char2。我們現在可以訪問其中的所有值，例如
jq -r '.frames.frame.lps.lp|.characters[]|[.code_ascii,.confidence]|@tsv'完整的管道：
awk '/"characater"/ { sub("\"characater\"", "\"char" ++n "\"", $0) } 1' file.json | jq -r '.frames.frame.lps.lp|.characters[]|[.code_ascii,.confidence]|@tsv'結果（給定問題中的數據）：
1 97 5 89 4 97 5 97 1 77 B 97 B 94 L 34如果您控制 JSON 文件的生成，則應考慮將
characters對象轉換為適當的數組。