{"id":1160,"date":"2018-10-25T09:58:08","date_gmt":"2018-10-25T00:58:08","guid":{"rendered":"https:\/\/www.amano-labo.jp\/pages\/?p=1160"},"modified":"2018-10-25T09:58:08","modified_gmt":"2018-10-25T00:58:08","slug":"awk%e7%89%88vlookup","status":"publish","type":"post","link":"https:\/\/www.amano-labo.jp\/pages\/tips\/1160\/","title":{"rendered":"awk\u7248vlookup"},"content":{"rendered":"<div class=\"amano- amano-entity-placement\" id=\"amano-1252059349\"><div id=\"amano-84121978\"><a href=\"https:\/\/www.amano-labo.jp\/pages\/blog\/1941\/\" aria-label=\"amls2\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.amano-labo.jp\/pages\/wp-content\/uploads\/2020\/09\/amls2.png\" alt=\"\"  srcset=\"https:\/\/www.amano-labo.jp\/pages\/wp-content\/uploads\/2020\/09\/amls2.png 1000w, https:\/\/www.amano-labo.jp\/pages\/wp-content\/uploads\/2020\/09\/amls2-300x24.png 300w, https:\/\/www.amano-labo.jp\/pages\/wp-content\/uploads\/2020\/09\/amls2-768x61.png 768w, https:\/\/www.amano-labo.jp\/pages\/wp-content\/uploads\/2020\/09\/amls2-100x8.png 100w, https:\/\/www.amano-labo.jp\/pages\/wp-content\/uploads\/2020\/09\/amls2-150x12.png 150w, https:\/\/www.amano-labo.jp\/pages\/wp-content\/uploads\/2020\/09\/amls2-200x16.png 200w, https:\/\/www.amano-labo.jp\/pages\/wp-content\/uploads\/2020\/09\/amls2-450x36.png 450w, https:\/\/www.amano-labo.jp\/pages\/wp-content\/uploads\/2020\/09\/amls2-600x48.png 600w, https:\/\/www.amano-labo.jp\/pages\/wp-content\/uploads\/2020\/09\/amls2-900x72.png 900w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" width=\"1000\" height=\"80\"   \/><\/a><\/div><\/div><p>\u30c7\u30fc\u30bf\u306e\u691c\u7d22\u30fb\u5bfe\u5fdc\u4ed8\u3051\u3092\u884c\u3046\u5f37\u529b\u304b\u3064\u7c21\u5358\u306a\u624b\u6cd5\u306e\u4e00\u3064\u306bExcel\u306b\u304a\u3051\u308bvlookup\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>vlookup\u306f\u691c\u7d22\u30ad\u30fc\u3068\u306a\u308b1\u5217\u3068\u3001\u691c\u7d22\u5bfe\u8c61\u3068\u306a\u308b\u30c7\u30fc\u30bf\u884c\u5217\u3092\u5bfe\u8c61\u306b\u884c\u3046\u51e6\u7406\u3067\u3059\u3002\u691c\u7d22\u30ad\u30fc\u306b\u5408\u81f4\u3059\u308b\u3001\u30c7\u30fc\u30bf\u884c\u5217\u306e1\u5217\u76ee\u306e\u3042\u308b\u884c\u3092\u898b\u3064\u3051\u51fa\u3057\u3001\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n<p>\u5148\u65e5\u3001\u81a8\u5927\u306a\u6642\u7cfb\u5217\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066vlookup\u3092\u884c\u3063\u305f\u3068\u3053\u308d\u30011\u53f0\u306ePC\u3067\u306f\u534a\u65e5\u4ee5\u4e0a\uff08\u4fdd\u5b58\u3059\u308b\u305f\u3073\uff09\u3001\u3082\u30461\u53f0\u306ePC\u3067\u306fExcel\u304c\u843d\u3061\u308b\u3068\u3044\u3046\u6709\u69d8\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002<\/p>\n<p>\u4ed6\u306b\u3082\u624b\u7acb\u3066\u306f\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u9762\u5012\u306b\u306a\u3063\u305f\u306e\u3067awk\u3067\u540c\u69d8\u306e\u51e6\u7406\u3092\u5b9f\u88c5\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u5b9f\u884c\u6642\u306e\u5f15\u6570\u3068\u3057\u3066\u3001list1.txt\u306b\u306f\u30ad\u30fc\u5217\u3068\u306a\u308b\u30c7\u30fc\u30bf\u306e\u5165\u3063\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u3001list2.txt\u306b\u306f\u5bfe\u8c61\u3068\u306a\u308b\u30c7\u30fc\u30bf\u884c\u5217\u306e\u30d5\u30a1\u30a4\u30eb\uff08\u3044\u305a\u308c\u3082CSV\u3092\u60f3\u5b9a\uff09\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<p>Excel\u3067\u306f\u6307\u5b9a\u3057\u305f1\u5217\u3060\u3051\u3092\u62bd\u51fa\u3057\u307e\u3059\u304c\u3001\u3053\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u306f2\u5217\u76ee\u4ee5\u964d\u3092\u3059\u3079\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"lang: decode:true\"># awk\u7248vlookup\r\n# N.Amano\r\n# v 3.0 : 2018\/10\/25\r\n# v 1.0 : 2018\/10\/25\r\n#\r\n# awk -f vlookup03.awk -v leftfile=list1.txt list2.txt\r\n#\r\n\r\nBEGIN {\r\n\tFS=\",\";\r\n\t\r\n\t# \u691c\u7d22\u5bfe\u8c61\u30c7\u30fc\u30bf\u306e\u4e00\u62ec\u8aad\u307f\u8fbc\u307f\r\n\r\n\t# 1\u884c\u76ee\u3092\u30d8\u30c3\u30c0\u30fc\u3068\u3059\u308b\r\n\tgetline;\r\n\tprintf(\"%s\\n\", $0);\r\n\t\r\n\t# \u6b8b\u308a\u3092\u30e1\u30e2\u30ea\u30fc\u4e0a\u306b\u8aad\u307f\u8fbc\u307f\r\n\twhile (getline &gt; 0) {\r\n\t\tdata2[$1] = $0;\r\n\t}\r\n\t\r\n\t# \u691c\u7d22\u30ad\u30fc\u30921\u884c\u305a\u3064\u8aad\u307f\u8fbc\u3093\u3067\u691c\u7d22\r\n\twhile ((getline &lt; leftfile) &gt; 0) {\r\n\t\toutLine = data2[$1];\r\n\t\tif (outLine == null) {\r\n\t\t\toutLine = $1;\r\n\t\t}\r\n\t\tprintf(\"%s\\n\", outLine);\r\n\t}\r\n}<\/pre>\n<p>\u6700\u521d\u306b\u4f5c\u3063\u305f\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u306f\u4f7f\u7528\u30e1\u30e2\u30ea\u30fc\u91cf\u3092\u6291\u5236\u3059\u308b\u305f\u3081\u306b\u3001\u4e21\u65b9\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u9010\u6b21\u8aad\u307f\u8fbc\u307f\u3068\u3057\u307e\u3057\u305f\u3002\u6570\u6642\u9593\u3067\u7d42\u308f\u308b\u3060\u308d\u3046\u3068\u591c\u9593\u653e\u7f6e\u3057\u3066\u304a\u304d\u307e\u3057\u305f\u304c\u3001\u534a\u65e5\u3067\u534a\u5206\u3057\u304b\u51e6\u7406\u304c\u7d42\u308f\u3063\u3066\u3044\u307e\u305b\u3093\u3067\u3057\u305f&#8230;\u3002<\/p>\n<p>\u305d\u3053\u3067\u3001\u3057\u3087\u305b\u3093\u306f\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3001\u4f7f\u7528\u30e1\u30e2\u30ea\u30fc\u91cf\u3082\u305f\u304b\u304c\u3057\u308c\u3066\u3044\u308b\u3068\u3044\u3046\u3088\u3046\u306b\u8003\u3048\u76f4\u3057\u3001\u691c\u7d22\u3059\u308b\u305f\u3081\u306b\u4f55\u5ea6\u3082\u7e70\u308a\u8fd4\u3057\u30a2\u30af\u30bb\u30b9\u3059\u308b\u30c7\u30fc\u30bf\u884c\u5217\u3092\u30aa\u30f3\u30e1\u30e2\u30ea\u30fc\u3068\u3059\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002\u901f\u5ea6\u5dee\u306f\u8a08\u6e2c\u3059\u308b\u307e\u3067\u3082\u306a\u3044\u307b\u3069\u9055\u3044\u307e\u3057\u305f\uff08\u3053\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u306a\u3089\u6570\u79d2\u3067\u7d42\u308f\u3063\u305f\uff09\u3002<\/p>\n<p>\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306e\u6642\u9593\u3068\u3053\u306e\u30d6\u30ed\u30b0\u3092\u66f8\u304f\u6642\u9593\u3092\u5408\u308f\u305b\u3066\u3082\u3001\u5727\u5012\u7684\u306a\u6642\u9593\u524a\u6e1b\u306b\u3064\u306a\u304c\u308a\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30c7\u30fc\u30bf\u306e\u691c\u7d22\u30fb\u5bfe\u5fdc\u4ed8\u3051\u3092\u884c\u3046\u5f37\u529b\u304b\u3064\u7c21\u5358\u306a\u624b\u6cd5\u306e\u4e00\u3064\u306bExcel\u306b\u304a\u3051\u308bvlookup\u304c\u3042\u308a\u307e\u3059\u3002 vlookup\u306f\u691c\u7d22\u30ad\u30fc\u3068\u306a\u308b1\u5217\u3068\u3001\u691c\u7d22\u5bfe\u8c61\u3068\u306a\u308b\u30c7\u30fc\u30bf\u884c\u5217\u3092\u5bfe\u8c61\u306b\u884c\u3046\u51e6\u7406\u3067\u3059\u3002\u691c\u7d22\u30ad\u30fc\u306b\u5408\u81f4\u3059\u308b\u3001\u30c7\u30fc\u30bf\u884c\u5217\u306e1\u5217 <a class=\"more-link\" href=\"https:\/\/www.amano-labo.jp\/pages\/tips\/1160\/\">\u7d9a\u304d\u3092\u8aad\u3080\u2026<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6,4],"tags":[48,26],"class_list":["post-1160","post","type-post","status-publish","format-standard","hentry","category-software","category-tips","tag-awk","tag-26"],"_links":{"self":[{"href":"https:\/\/www.amano-labo.jp\/pages\/wp-json\/wp\/v2\/posts\/1160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amano-labo.jp\/pages\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amano-labo.jp\/pages\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amano-labo.jp\/pages\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amano-labo.jp\/pages\/wp-json\/wp\/v2\/comments?post=1160"}],"version-history":[{"count":1,"href":"https:\/\/www.amano-labo.jp\/pages\/wp-json\/wp\/v2\/posts\/1160\/revisions"}],"predecessor-version":[{"id":1161,"href":"https:\/\/www.amano-labo.jp\/pages\/wp-json\/wp\/v2\/posts\/1160\/revisions\/1161"}],"wp:attachment":[{"href":"https:\/\/www.amano-labo.jp\/pages\/wp-json\/wp\/v2\/media?parent=1160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amano-labo.jp\/pages\/wp-json\/wp\/v2\/categories?post=1160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amano-labo.jp\/pages\/wp-json\/wp\/v2\/tags?post=1160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}