[B! jq] opparaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

oppara id:oppara

jqã«é–¢ã™ã‚‹opparaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ãƒ‘ã‚¤ãƒ—ãƒ©ã‚¤ãƒ³æŒ‡å‘JSONå‡¦ç†ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªž jq - æªœå±±æ£å¹¸ã®ã‚ãƒžã‚¤ãƒ©é£¼è‚²è¨˜ (ã¯ã¦ãªBlog)
jqï¼ˆhttps://stedolan.github.io/jq/ï¼‰ã®ç´¹ä»‹ã§ã¯ã€ã€ŒJSONå‡¦ç†ã®ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã€ˆä¸€è¡Œé‡ŽéƒŽã€‰ã¨ã—ã¦ã‚ã¡ã‚ƒãã¡ã‚ƒä¾¿åˆ©ï¼ã€ã¨ã‚¢ãƒ”ãƒ¼ãƒ«ã™ã‚‹ã®ãŒå®šç•ªã§ã™ã€‚ã‚‚ã¡ã‚ã‚“ãã‚Œã¯æœ¬å½“ã§ã€ã€Œã‚ã¡ã‚ƒãã¡ã‚ƒä¾¿åˆ©ï¼ã€ã§ã™ã€‚ãŒã€å®Ÿã¯ jq ã¯ã€ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼è¨˜è¿°ã«ã¨ã©ã¾ã‚‰ãªã„ã€ã‹ãªã‚Šæœ¬æ ¼çš„ãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã™ã€‚ JSONå‡¦ç†ã®ãŸã‚ã®DSLã€ˆDomain Specific Language | é ˜åŸŸç‰¹åŒ–è¨€èªžã€‰ãªã®ã§ã€æ±Žç”¨è¨€èªžã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã—ã‹ã—ã€æ±Žç”¨è¨€èªžãŒå‚™ãˆã¦ã„ã‚‹è¨€èªžæ©Ÿèƒ½ã®ä¸€éƒ¨ï¼ˆé–¢æ•°å®šç¾©ã€ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚·ã‚¹ãƒ†ãƒ ãªã©ï¼‰ã‚’ jq ã‚‚æŒã£ã¦ã„ã¾ã™ã€‚ã¾ãŸ jq ã¯ã€ç‹¬ç‰¹ã§æ¥½ã—ã„ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãƒ»ãƒ‘ãƒ©ãƒ€ã‚¤ãƒ -- â€œãƒ‘ã‚¤ãƒ—ãƒ©ã‚¤ãƒ³æŒ‡å‘â€ã«åŸºã¥ã„ã¦è¨è¨ˆã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã‚’è¶…ãˆãŸ jq ã®ä½¿ã„æ–¹ã¨ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã¨ã—ã¦ã® jq ã®ç‰¹å¾´ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚é•·ã„è¨˜äº‹ã«ãªã£ã¦ã—ã¾ã£ãŸã®ã§ã€ä¸€
oppara 2022/12/07
cli

jq

tips
ãƒªãƒ³ã‚¯
jq ã§ JSON ã‚’ LTSV ã«å¤‰æ›ã™ã‚‹ - tkuchikiã®æ—¥è¨˜
çµè«– [ {"foo": "bar1", "hoge": "piyo1"}, {"foo": "bar2", "hoge": "piyo2"}, {"foo": "bar3", "hoge": "piyo3"} ] ã¨ã„ã† json(test.json ã¨ã™ã‚‹) ãŒã‚ã‚‹ã¨ãã«ã€ $ cat test.json | jq -r '.[] | to_entries | map("\(.key):\(.value)") | join("\t")' ã¨å®Ÿè¡Œã™ã‚‹ã¨ã€ foo:bar1 hoge:piyo1 foo:bar2 hoge:piyo2 foo:bar3 hoge:piyo3 ã¨å‡ºåŠ›ã•ã‚Œã¾ã™ã€‚ è§£èª¬ åˆ†è§£ã—ã¦èª¬æ˜Žã—ã¾ã™ã€‚ to_entries ã§ key, value ã¨ã„ã† key ã‚’æŒã£ãŸ hash ã® array ã«å¤‰æ›ã—ã¾ã™ã€‚ $ cat test.json | jq -r '.[]
oppara 2022/09/01
jq

json

ltsv
ãƒªãƒ³ã‚¯
jqã‚³ãƒžãƒ³ãƒ‰ã§é›†è¨ˆ group by, max, sum, count
jq ã‚³ãƒžãƒ³ãƒ‰ã§é›†è¨ˆï¼ˆæœ€å¤§ã€åˆè¨ˆã€æ•°ã€å¹³å‡ã€ä¸¦ã³æ›¿ãˆï¼‰ã‚’ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚jq ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 1.6ã€‚ ä»¥å‰æ›¸ã„ãŸ jq ã‚³ãƒžãƒ³ãƒ‰ã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã®ç¶šãã§ã™ã€‚ ç›®æ¬¡ ã‚µãƒ³ãƒ—ãƒ«ã® JSON æœ€å¤§å€¤ï¼ˆmax_byï¼‰ åˆè¨ˆå€¤ï¼ˆaddï¼‰ é…åˆ—ã®æ•°ï¼ˆlengthï¼‰ ã‚°ãƒ«ãƒ¼ãƒ—ã”ã¨ã®æœ€å¤§å€¤ (group_by, max_by) ã‚°ãƒ«ãƒ¼ãƒ—ã”ã¨ã®åˆè¨ˆå€¤ (group_by, add) ã‚°ãƒ«ãƒ¼ãƒ—ã”ã¨ã®é…åˆ—ã®æ•° (group_by, length) ã‚°ãƒ«ãƒ¼ãƒ—ã”ã¨ã®å¹³å‡ (group_by, add/length) é›†è¨ˆå¾Œã®ä¸¦ã³æ›¿ãˆ (sort_by) çµžã‚Šè¾¼ã‚“ã§ã‹ã‚‰é›†è¨ˆ (select) reduce ã‚’ä½¿ã£ãŸé›†è¨ˆ ã‚µãƒ³ãƒ—ãƒ«ã® JSON ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦ä»¥ä¸‹ã® JSON ã‚’ä½¿ã„ã¾ã™ã€‚æ³¨æ–‡ãƒ‡ãƒ¼ã‚¿ã®ã‚¤ãƒ¡ãƒ¼ã‚¸ã§ã™ã€‚ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ã¦ $JSON ã¨ã„ã†å¤‰æ•°ã«å…¥ã‚Œã¦ãŠãã¾ã™ã€‚ JSON=$(cat
oppara 2022/01/05
jq

tips
ãƒªãƒ³ã‚¯
jqã®Goå®Ÿè£… gojq ã‚’ä½œã‚Šã¾ã—ãŸï¼ â€• ã‚¹ã‚¿ãƒƒã‚¯ãƒžã‚·ãƒ³åž‹ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ—ãƒªã‚¿ã«ã‚ˆã‚‹ã‚¤ãƒ†ãƒ¬ãƒ¼ã‚¿ã‚»ãƒžãƒ³ãƒ†ã‚£ã‚¯ã‚¹ã®å®Ÿè£… - ãƒ—ãƒã‚°ãƒ©ãƒ ãƒ¢ã‚°ãƒ¢ã‚°
jqã¯ã¨ã¦ã‚‚ä¾¿åˆ©ãªã‚³ãƒžãƒ³ãƒ‰ã§ã™ã€‚ JSONã‚’è¿”ã™APIã‚’å®Ÿè£…ã™ã‚‹ã¨ãã‚„ã€SaaSã®APIã‹ã‚‰ç‰¹å®šã®æƒ…å ±ã‚’æŠœãå‡ºã—ã¦ã‚·ã‚§ãƒ«å¤‰æ•°ã«ä»£å…¥ã™ã‚‹ã¨ããªã©ã€webé–‹ç™ºã‚„é‹ç”¨ã«ã¯æ¬ ã‹ã›ãªã„ãƒ„ãƒ¼ãƒ«ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ã—ã‹ã—ã€ç§ã«ã¨ã£ã¦jqã®ã‚¯ã‚¨ãƒªã‚’ä¸€ç™ºã§æ›¸ãã®ã¯å®¹æ˜“ã§ã¯ãªãã€æ€ã„é€šã‚Šã®å‡ºåŠ›ãŒå¾—ã‚‰ã‚Œãªã„ã“ã¨ãŒã‚ˆãã‚ã‚Šã¾ã—ãŸã€‚ é›£ã—ã„ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã«æ‚©ã¾ã•ã‚Œã¦ã€jqã§æ›¸ãã®ã‚’è«¦ã‚ã¦åˆ¥ã®è¨€èªžã§æ›¸ãç›´ã™ã“ã¨ã‚‚ã‚ã‚Šã¾ã—ãŸã€‚ jqã®åå…«ç•ªã¨æ€ãˆã‚‹å ´é¢ã§ä½¿ã„ã“ãªã›ãªã„ã®ã¯ã€ãªã‹ãªã‹æ‚”ã—ã„ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ã®ãŒé›£ã—ã„ãªã‚‰ã€åŒã˜ã‚‚ã®ã‚’ä½œã£ã¦ã—ã¾ãˆã°ã‚ˆã„ã®ã§ã™ã€‚ jqã®å…¨ã¦ã®æ©Ÿèƒ½ã‚’å®Ÿè£…ã™ã‚‹ jqã‚’è¨€èªžã¨ã—ã¦ãã¡ã‚“ã¨æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã‚‹ jqã‚’å®Œå…¨ã«ç†è§£ã™ã‚‹ jqã®å…¨ã¦ã®æ©Ÿèƒ½ã‚’è‡ªåˆ†ã§å®Ÿè£…ã—ã¦ã—ã¾ãˆã°ã€jqãŒã©ã†ã„ã†ã‚‚ã®ã‹ã€ã‚¯ã‚¨ãƒªãŒã©ã®ã‚ˆã†ã«å‡¦ç†ã•ã‚Œã‚‹ã®ã‹ã€è©³ã—ããªã‚Œã‚‹ã¯ãšã§ã™ã€‚ jqã‚’å¾—æ„ãªè¨€èªžã¨è¨€ãˆã‚‹ã‚ˆã†ã«ãªã£ã¦ã€ã‚¯
oppara 2021/11/27
golang

jq

howto
ãƒªãƒ³ã‚¯
è»½é‡JSONãƒ‘ãƒ¼ã‚µãƒ¼ã€Žjqã€ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆï¼šã€Žjq Manualã€ã‚’ã–ã£ãã‚Šæ—¥æœ¬èªžè¨³ã—ã¦ã¿ã¾ã—ãŸ | DevelopersIO
jq Manual jqã§ç°¡å˜JSONåŠ å·¥ ï½œ Developers.IO jqã‚³ãƒžãƒ³ãƒ‰ãŒå®Ÿã¯é«˜æ€§èƒ½ã™ãŽã¦ãƒ“ãƒ“ãƒƒãŸè©± - beatsync.net JSONã‚’è¶…çµ¶ã«èªã¿ã‚„ã™ãã™ã‚‹ jq ã‚³ãƒžãƒ³ãƒ‰ - WebAPIãƒãƒªãƒãƒªä½¿ã†oré–‹ç™ºã™ã‚‹äººå¿…é ˆ CLIã§JSONã®æ•´å½¢ã‚’ã™ã‚‹ - ( ê’ªâŒ“ê’ª) ã‚†ã‚‹ã‚ˆã‚æ—¥è¨˜ JSONå½¢å¼ã®æƒ…å ±ã‚’æ§˜ã€…ãªæ¡ä»¶ã‚„æ›¸å¼ã¨ã—ã¦æˆå½¢ã€ãƒ•ã‚£ãƒ«ã‚¿ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã€Žjqã€ã€‚ä¸Šè¨˜é–¢é€£ã‚¨ãƒ³ãƒˆãƒªã§ç§ã‚‚ã“ã®ãƒ„ãƒ¼ãƒ«ã®å˜åœ¨ã‚’çŸ¥ã‚‹äº‹ã«ãªã£ãŸã®ã§ã™ãŒã€ãƒ„ãƒ¼ãƒ«ã®ç°¡æ˜“ã•ãƒ»ä¾¿åˆ©ã•ã«æ„Ÿå‹•ã—ãªãŒã‚‰ç§ã‚‚ã¡ã‚‡ãã¡ã‚‡ãåˆ©ç”¨ã•ã›ã¦ã‚‚ã‚‰ã£ã¦ã„ã¾ã™ã€‚ ãã“ã§ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€jqå…¬å¼ãƒšãƒ¼ã‚¸ã«å±•é–‹ã•ã‚Œã¦ã„ã‚‹åˆ©ç”¨ã‚¬ã‚¤ãƒ‰ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹çš„ãªä½ç½®ä»˜ã‘ã®ã€Žjq Manualã€ã‚’å†™çµŒãŒã¦ã‚‰ã–ã£ãã‚Šæ—¥æœ¬èªžè¨³ã—ã¦ã¿ã¾ã—ãŸã€‚ã–ã£ãã‚Šè¨³ãªã®ã§ã“ã®éƒ¨åˆ†ã®è¨³ãŠã‹ã—ã„ãƒ»é–“é•ã£ã¦ã‚‹ç‰ã‚ã‚Šã¾ã—ãŸã‚‰å¾¡æŒ‡æ‘˜é ‚ã‘ã‚‹ã¨å¹¸ã„ã§ã™ã€‚ä¾‹ç¤ºã•ã‚Œã¦ã„ã‚‹ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã‚‚
oppara 2021/10/16
jq

manual
ãƒªãƒ³ã‚¯
GitHub - mgdm/htmlq: Like jq, but for HTML.
oppara 2021/09/08
jq

html

selector

cli

tool
ãƒªãƒ³ã‚¯
S3ãƒã‚±ãƒƒãƒˆã®ãƒ©ã‚¤ãƒ•ã‚µã‚¤ã‚¯ãƒ«ãƒ«ãƒ¼ãƒ«ã‚’ä¸€æ‹¬ã§æ›´æ–°ã™ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œæˆã—ã¦ã¿ãŸ | DevelopersIO
7æœˆã‹ã‚‰ã‚¢ãƒŽãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ ãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ã‚µãƒãƒ¼ãƒˆãƒãƒ¼ãƒ ã«JOINã—ã¾ã—ãŸ å·å´Žã§ã™ã€‚ S3ã®ãƒ©ã‚¤ãƒ•ã‚µã‚¤ã‚¯ãƒ«è¨å®š S3ã®ãƒ©ã‚¤ãƒ•ã‚µã‚¤ã‚¯ãƒ«è¨å®šã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€ãƒã‚±ãƒƒãƒˆå†…ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ©ã‚¤ãƒ•ã‚µã‚¤ã‚¯ãƒ«ç®¡ç†ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ å‰å›žã®ãƒ–ãƒã‚°ã§ã¯ã€AWS CLIã® s3api ã‚’ä½¿ç”¨ã—ã¦ã€æŒ‡å®šã®ãƒ©ã‚¤ãƒ•ã‚µã‚¤ã‚¯ãƒ«ãƒ«ãƒ¼ãƒ«ãŒä»˜ä¸Žã•ã‚Œã¦ã„ãªã„S3ãƒã‚±ãƒƒãƒˆã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œæˆã—ã¾ã—ãŸã€‚ S3ã®ãƒ©ã‚¤ãƒ•ã‚µã‚¤ã‚¯ãƒ«è¨å®šã‚’æ›´æ–°ã™ã‚‹éš›ã®èª²é¡Œ ãƒ©ã‚¤ãƒ•ã‚µã‚¤ã‚¯ãƒ«è¨å®šã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆãŒã§ãã‚Œã°ã€ ãƒ©ã‚¤ãƒ•ã‚µã‚¤ã‚¯ãƒ«è¨å®šã‚’æ›´æ–°ã™ã‚‹ã‚ˆã†ã€ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä¿®æ£ã™ã‚‹ã®ã¯ã€ä¸€è¦‹ç°¡å˜ãã†ã«æ€ãˆã¾ã™ã€‚ æ—¢å˜è¨å®šãŒæ¶ˆãˆã¦ã—ã¾ã† ã¨ã“ã‚ãŒã€ä¸€ç‚¹æ³¨æ„ãŒå¿…è¦ãªã¨ã“ã‚ãŒã‚ã‚Šã€ãã‚ŒãŒä¸‹è¨˜ãƒ–ãƒã‚°ã®å†…å®¹ã«ãªã‚Šã¾ã™ã€‚ â†’ æ–°ã—ã„ãƒ«ãƒ¼ãƒ«ã‚’è¿½åŠ â†’ æ–°è¦ã«ãƒ«ãƒ¼ãƒ«ã‚’è¿½åŠ ã—ãŸã„å ´åˆã¯ã€ã¾ãšã¯æ—¢å˜ã®ãƒ«ãƒ¼ãƒ«ã¨æ–°è¦ãƒ«ãƒ¼ãƒ«ã‚’ã¾ã¨ã‚ãŸJSONã‚’ç”¨æ„ã—ã¾ã™ã€‚ ä¾‹ã‚’æŒ™ã’ã¦èª¬æ˜Žã„
oppara 2021/08/23
aws

s3

jq
ãƒªãƒ³ã‚¯
jqã‚’åˆ©ç”¨ã—ã¦ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å‡¦ç†æ¸ˆã¿ã®JSONæ–‡å—åˆ—ã‚’ä½œæˆã™ã‚‹æ–¹æ³• | DevelopersIO
ã“ã‚“ã«ã¡ã¯ï¼DA(ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹)äº‹æ¥æœ¬éƒ¨ ã‚µãƒ¼ãƒ“ã‚¹ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³éƒ¨ã®å¤§é«˜ã§ã™ã€‚ æœ¬ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€jqã‚’åˆ©ç”¨ã—ã¦ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å‡¦ç†æ¸ˆã¿ã®JSONæ–‡å—åˆ—ã‚’ä½œæˆã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ çµè«– çµè«–ã‹ã‚‰è¨€ã†ã¨ã€ä¸‹è¨˜ã®ã‚ˆã†ãªã‚³ãƒžãƒ³ãƒ‰ã§ä½œæˆã§ãã¾ã™ã€‚ $ cat event-detail.json | jq '@json' > escaped-event-detail.json ã‚„ã‚ŠãŸã„ã“ã¨ ãŸã¨ãˆã°ã€AWS CLIã‚’åˆ©ç”¨ã™ã‚‹æ™‚ãªã©ã«ã€ä»¥ä¸‹ã®ã‚ˆã†ãªãƒªã‚¯ã‚¨ã‚¹ãƒˆå½¢å¼ã‚’æŒã¤APIãŒã‚ã‚Šã¾ã™ã€‚ [ { "Time": timestamp, "Source": "string", "Resources": ["string", ...], "DetailType": "string", "Detail": "string", "EventBusName": "string", "TraceHeade
oppara 2021/08/18
json

jq

escape
ãƒªãƒ³ã‚¯
é…åˆ—ã‚„nullï¼ˆç‰¹å®šã®ã‚ãƒ¼ãŒãªã„ï¼‰ãŒã‚ã‚‹JSONã‹ã‚‰jqã§TSVä½œã£ã¦ã¿ãŸ | DevelopersIO
jqã‚’ä½¿ã£ã¦JSONã‹ã‚‰TSVã‚’ä½œã‚ŠãŸã‹ã£ãŸã®ã§ã™ãŒã€ã‚„ã‚Šå§‹ã‚ã¦ã‹ã‚‰ ã“ã®JSONã€ä¸ã«é…åˆ—æŒã£ã¦ã‚‹ã‚...ã€‚ ã‚ã€ã“ã®keyã‚’æŒã£ã¦ãªã„ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚‚ã‚ã‚‹ã—...ã€‚ ã¨æ°—ä»˜ãã¾ã—ãŸã€‚ JSONã¯å˜ãªã‚‹KeyValueã«é™ã‚‰ãšã€Valueã¨ã—ã¦é…åˆ—ãªã©ã‚‚æŒã¤ã“ã¨ãŒã§ãã¾ã™ã—ã€ ãƒ•ã‚¡ã‚¤ãƒ«ã«å«ã¾ã‚Œã¦ã„ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå…¨ã¦åŒã˜Keyé …ç›®ã‚’æŒã£ã¦ã„ã‚‹ã“ã¨ãªã©ã‚‚ã¡ã‚ã‚“ä¿è¨¼ã§ãã¾ã›ã‚“ã€‚ ã“ã®è¾ºã‚’è€ƒæ…®ã§ããªã„ã¨2æ¬¡å…ƒã®TSVã«è½ã¨ã™ã“ã¨ã¯ã§ãã¾ã›ã‚“ã€‚ æœ€åˆã¯è«¦ã‚ã¦Pythonã®ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã“ã†ã‹ã¨æ€ã£ãŸã®ã§ã™ãŒã€ èª¿ã¹ã¦ã¿ã‚‹ã¨jqãªã‚‰é›£ãªãã§ãã‚‹ã“ã¨ãŒã‚ã‹ã‚Šã¾ã—ãŸï¼ ä»Šå›žã¯ã€é…åˆ—ã¯å˜ç´”ã«ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã®æ–‡å—åˆ—ã«ã§ãã‚‹ã‚‚ã®ã¨ã—ã¦ã€ é…åˆ—ã‚’å«ã‚€JSONã‹ã‚‰TSVã‚’ä½œã‚‹å‡¦ç†ã‚’è¡Œã£ã¦ã¿ã¾ã—ãŸã€‚ å…·ä½“çš„ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªJSONã‹ã‚‰ test.json [ { "job": { "jobId": "sample_job_01"
oppara 2021/06/23
jq

tips

null
ãƒªãƒ³ã‚¯
jqã‚³ãƒžãƒ³ãƒ‰è¦šãˆæ›¸ã
JSON ã‹ã‚‰å¿…è¦ãªã‚‚ã®ã‚’å–ã‚Šå‡ºã™ã¨ãã«ä½¿ã† jq ã‚³ãƒžãƒ³ãƒ‰ã€‚ä½¿ã„æ–¹ã‚’ã™ãå¿˜ã‚Œã¦ã—ã¾ã£ã¦æ¯Žå›ž jq Manual ã‚’è¦‹ã¦ã„ã‚‹ã®ã§ã€ã‚ˆãä½¿ã†ãƒ•ã‚£ãƒ«ã‚¿ã‚’ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚jq ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 1.6ã€‚éšæ™‚æ›´æ–°ã€‚ ç›®æ¬¡ ã‚µãƒ³ãƒ—ãƒ«ã® JSON æº–å‚™ JSON ã‚’ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ é…åˆ—ã®ä¸èº«ã‚’ã™ã¹ã¦å–ã‚Šå‡ºã™ ç‰¹å®šã®é…åˆ—ã®è¦ç´ ã‚’å–ã‚Šå‡ºã™ ã‚ãƒ¼ã‚’æŒ‡å®šã—ã¦å€¤ã‚’å–ã‚Šå‡ºã™ è¤‡æ•°ã®å€¤ã‚’å–ã‚Šå‡ºã™ ãƒ€ãƒ–ãƒ«ã‚¯ã‚©ãƒ¼ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ¶ˆã™ CSV å½¢å¼ã§å‡ºåŠ›ã™ã‚‹ TSV å½¢å¼ã§å‡ºåŠ›ã™ã‚‹ çµžã‚Šè¾¼ã¿æ¤œç´¢ã‚’ã™ã‚‹ and/or æ¤œç´¢ æ£è¦è¡¨ç¾ã§æ¤œç´¢ æ–‡å—åˆ—ã®çµåˆ null å…¥åŠ› é›†è¨ˆ æ—¥ä»˜ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆå¤‰æ›´ã¨ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³å¤‰æ›´ ã‚µãƒ³ãƒ—ãƒ«ã® JSON æº–å‚™ ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦ä»¥ä¸‹ã® JSON ã‚’ä½¿ã„ã¾ã™ã€‚ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ã¦ $JSON ã¨ã„ã†å¤‰æ•°ã«å…¥ã‚Œã¦ãŠãã¾ã™ã€‚ JSON=$(cat << EOS [ { "Address":
oppara 2021/04/18
jq

tips
ãƒªãƒ³ã‚¯
ijq: Interactive jq
oppara 2021/03/01
jq

interactive

json
ãƒªãƒ³ã‚¯
GitHub - reegnz/jq-zsh-plugin: jq zsh plugin
oppara 2021/01/05
jq

plugin

zsh
ãƒªãƒ³ã‚¯
1