{"id":1394,"date":"2020-05-17T20:48:41","date_gmt":"2020-05-17T11:48:41","guid":{"rendered":"https:\/\/hi3103.net\/notes\/?p=1394"},"modified":"2022-10-29T09:53:06","modified_gmt":"2022-10-29T00:53:06","slug":"google%e3%82%b9%e3%83%97%e3%83%ac%e3%83%83%e3%83%89%e3%82%b7%e3%83%bc%e3%83%88%e3%81%a7%e5%8d%8a%e8%a7%92%e3%82%ab%e3%82%bf%e3%82%ab%e3%83%8a%e3%82%92%e5%85%a8%e8%a7%92%e3%82%ab%e3%82%bf%e3%82%ab","status":"publish","type":"post","link":"https:\/\/hi3103.net\/notes\/google\/1394","title":{"rendered":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u534a\u89d2\u30ab\u30bf\u30ab\u30ca\u3092\u5168\u89d2\u30ab\u30bf\u30ab\u30ca\u306b\u5909\u63db\u3059\u308b\u95a2\u6570\u300cf7conv\u300d\u3092GAS\u3067\u4f5c\u308b"},"content":{"rendered":"<h3>\u6982\u8981<\/h3>\n<ul>\n<li>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u3067\u300c\u534a\u89d2\u30ab\u30bf\u30ab\u30ca\u300d\u3092\u300c\u5168\u89d2\u30ab\u30bf\u30ab\u30ca\u300d\u306b\u5909\u63db\u3057\u305f\u304f\u306a\u3063\u305f\u3002<\/li>\n<li>\u8272\u3005\u63a2\u3057\u305f\u304c\u3001\u5148\u4eba\u304c\u4f5c\u6210\u3057\u305f\u3082\u306e\u306f\u300c\u30ac\u300d\u306a\u3069\u306e\u6fc1\u97f3\u306e\u5909\u63db\u6642\u306b\u300c\u30ab\u300d\u3068\u300c\u6fc1\u70b9\u300d\u306b\u5206\u5272\u3055\u308c\u3066\u3057\u307e\u3044\u3001\u305d\u306e\u307e\u307e\u4f7f\u7528\u3067\u304d\u306a\u304b\u3063\u305f\u3002<\/li>\n<li>\u4ee5\u4e0b\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3067\u516c\u958b\u3055\u308c\u3066\u3044\u308b\u30bd\u30fc\u30b9\u3092\u5143\u306b\u3001\u534a\u89d2\u30ab\u30bf\u30ab\u30ca\u2192\u5168\u89d2\u30ab\u30bf\u30ab\u30ca\u5909\u63db\u3060\u3051\u3092\u884c\u3046\u95a2\u6570\u306b\u6539\u9020\u3055\u305b\u3066\u3044\u305f\u3060\u3044\u305f\u3002\n<ul>\n<li><a href=\"https:\/\/www.pre-practice.net\/2017\/12\/blog-post.html\">Google Apps Script\u8a66\u884c\u932f\u8aa4Blog: \u5168\u89d2\u3072\u3089\u304c\u306a\u21d4\u5168\u89d2\u30ab\u30bf\u30ab\u30ca\u21d4\u534a\u89d2\uff76\uff80\uff76\uff85\u5909\u63db<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><!--more--><\/p>\n<h3>\u30bd\u30fc\u30b9<\/h3>\n<ul>\n<li>\u53c2\u8003\u30bd\u30fc\u30b9\u3067\u306f\u3001\u534a\u89d2\u30fb\u5168\u89d2\u30ab\u30bf\u30ab\u30ca\u306e\u30ea\u30b9\u30c8\u306b\u8a18\u53f7\u985e\u304c\u542b\u307e\u308c\u3066\u3044\u306a\u3044\u305f\u3081\u3001\u4ee5\u4e0b\u3092\u672b\u5c3e\u306b\u8ffd\u52a0\u3002\n<ul>\n<li>\u9577\u97f3\u8a18\u53f7\uff1a<code>\u30fc<\/code><\/li>\n<li>\u4e2d\u9ed2\uff1a<code>\u30fb<\/code><\/li>\n<li>\u53e5\u70b9\uff1a<code>\u3002<\/code><\/li>\n<li>\u8aad\u70b9\uff1a<code>\u3001<\/code><\/li>\n<\/ul>\n<\/li>\n<li>\u95a2\u6570\u540d\u306f\u3001F7\u30ad\u30fc\u306b\u3088\u308b\u5168\u89d2\u30ab\u30bf\u30ab\u30ca\u5909\u63db\u306b\u3061\u306a\u3093\u3067 <code>f7conv<\/code> \u3068\u3057\u305f\u3002<\/li>\n<li>Gist\u7248\u306f\u4ee5\u4e0b\u30ea\u30f3\u30af\u3092\u53c2\u7167\u3002\n<ul>\n<li><a href=\"https:\/\/gist.github.com\/hi3103\/c2f1f986d78d98a64df6205982b7051f\">\u30bd\u30fc\u30b9\u3092Gist\u3067\u307f\u308b<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre><code>\/\/\u5168\u89d2\u30ab\u30bf\u30ab\u30ca\u4e00\u89a7\nconst zenkata = [\n'\u30a2', '\u30a4', '\u30a6', '\u30a8', '\u30aa',\n'\u30ab', '\u30ad', '\u30af', '\u30b1', '\u30b3',\n'\u30b5', '\u30b7', '\u30b9', '\u30bb', '\u30bd',\n'\u30bf', '\u30c1', '\u30c4', '\u30c6', '\u30c8',\n'\u30ca', '\u30cb', '\u30cc', '\u30cd', '\u30ce',\n'\u30cf', '\u30d2', '\u30d5', '\u30d8', '\u30db',\n'\u30de', '\u30df', '\u30e0', '\u30e1', '\u30e2',\n'\u30e4', '\u30e6', '\u30e8',\n'\u30e9', '\u30ea', '\u30eb', '\u30ec', '\u30ed',\n'\u30ef', '\u30f2', '\u30f3',\n'\u30ac', '\u30ae', '\u30b0', '\u30b2', '\u30b4',\n'\u30b6', '\u30b8', '\u30ba', '\u30bc', '\u30be',\n'\u30c0', '\u30c2', '\u30c5', '\u30c7', '\u30c9',\n'\u30d0', '\u30d3', '\u30d6', '\u30d9', '\u30dc',\n'\u30d1', '\u30d4', '\u30d7', '\u30da', '\u30dd',\n'\u30a1', '\u30a3', '\u30a5', '\u30a7', '\u30a9',\n'\u30e3', '\u30e5', '\u30e7',\n'\u30c3', '\u30f4',\n'\u30fc', '\u30fb', '\u3002', '\u3001'];\n\n\/\/\u534a\u89d2\u30ab\u30bf\u30ab\u30ca\u4e00\u89a7\nconst hankata = [\n'\uff71', '\uff72', '\uff73', '\uff74', '\uff75',\n'\uff76', '\uff77', '\uff78', '\uff79', '\uff7a',\n'\uff7b', '\uff7c', '\uff7d', '\uff7e', '\uff7f',\n'\uff80', '\uff81', '\uff82', '\uff83', '\uff84',\n'\uff85', '\uff86', '\uff87', '\uff88', '\uff89',\n'\uff8a', '\uff8b', '\uff8c', '\uff8d', '\uff8e',\n'\uff8f', '\uff90', '\uff91', '\uff92', '\uff93',\n'\uff94', '\uff95', '\uff96',\n'\uff97', '\uff98', '\uff99', '\uff9a', '\uff9b',\n'\uff9c', '\uff66', '\uff9d',\n'\uff76\uff9e', '\uff77\uff9e', '\uff78\uff9e', '\uff79\uff9e', '\uff7a\uff9e',\n'\uff7b\uff9e', '\uff7c\uff9e', '\uff7d\uff9e', '\uff7e\uff9e', '\uff7f\uff9e',\n'\uff80\uff9e', '\uff81\uff9e', '\uff82\uff9e', '\uff83\uff9e', '\uff84\uff9e',\n'\uff8a\uff9e', '\uff8b\uff9e', '\uff8c\uff9e', '\uff8d\uff9e', '\uff8e\uff9e',\n'\uff8a\uff9f', '\uff8b\uff9f', '\uff8c\uff9f', '\uff8d\uff9f', '\uff8e\uff9f',\n'\uff67', '\uff68', '\uff69', '\uff6a', '\uff6b',\n'\uff6c', '\uff6d', '\uff6e',\n'\uff6f', '\uff73\uff9e',\n'\uff70', '\uff65', '\uff61', '\uff64'];\n\n\/\/\u95a2\u6570\u3092\u4f5c\u6210\nfunction f7conv(text) {\n  \/\/\u6700\u7d42\u7684\u306b\u8fd4\u3059\u5909\u6570\u3092\u5b9a\u7fa9\n  let result = '';\n\n  \/\/\u5909\u63db\u3059\u308b\u5bfe\u8c61\u6587\u5b57\u5217\u3092\u30bb\u30c3\u30c8\n  const input = hankata;\n  const output = zenkata;\n\n  \/\/\u5f15\u6570\u306b\u5024\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u304b\u30c1\u30a7\u30c3\u30af\n  if(typeof text === 'undefined') {\n    result = '\u30a8\u30e9\u30fc\uff1a\u5168\u89d2\u30ab\u30bf\u30ab\u30ca\u306b\u5909\u63db\u3059\u308b\u6587\u5b57\u5217\u304c\u6307\u5b9a\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002';\n  }else{\n    \/\/\u5f15\u6570\u3067\u6e21\u3055\u308c\u305f\u6587\u5b57\u5217\u3092\u5b9a\u6570\u306b\u30bb\u30c3\u30c8\n    const textStr = text;\n\n    \/\/1\u6587\u5b57\u305a\u3064\u5206\u5272\u3057\u3066\u914d\u5217\u306b\u683c\u7d0d\n    const textArr = textStr.split('');\n\n    \/\/\u6587\u5b57\u6570\u304c0\u3067\u306a\u3051\u308c\u3070\u5b9f\u884c\n    if(textArr.length !== 0){\n      \/\/\u6587\u5b57\u3092\u518d\u683c\u7d0d\u3059\u308b\u914d\u5217\u3092\u5b9a\u7fa9\n      let array = [];\n\n      \/\/\u5206\u5272\u3057\u305f\u6587\u5b57\u306e\u6570\u3060\u3051\u30eb\u30fc\u30d7\u3092\u56de\u3057\u3001\u3082\u3057\u6fc1\u70b9\u30fb\u534a\u6fc1\u70b9\u3060\u3063\u305f\u5834\u5408\u306f1\u3064\u524d\u306e\u914d\u5217\u306e\u4e2d\u8eab\u3068\u30bb\u30c3\u30c8\u306b\u3057\u3066 array \u306b\u683c\u7d0d\n      for (let i = 0; i &lt; textArr.length; i++) {\n        if (textArr[i] == '\uff9e' || textArr[i] == '\uff9f') {\n          array[array.length - 1] = (textArr[i - 1] + textArr[i]);\n        } else {\n          array.push(textArr[i]);\n        }\n      }\n\n      \/\/\u518d\u683c\u7d0d\u3057\u305f\u6587\u5b57\u306e\u6570\u3060\u3051\u30eb\u30fc\u30d7\u3092\u56de\u3057\u3001\u3082\u3057\u534a\u89d2\u30ab\u30ca\u304c\u3042\u3063\u305f\u3089\u5168\u89d2\u30ab\u30ca\u306b\u76f4\u3057\u3066 result \u3078\u683c\u7d0d\n      for (let j = 0; j &lt; array.length; j++) {\n        let index = input.indexOf(array[j]);\n        if (index == -1) {\n          result = result + array[j];\n        } else {\n          result = result + output[index];\n        }\n      }\n    }\n  }\n\n  \/\/\u7d50\u679c\u3092\u8fd4\u3059\n  return result;\n}<\/code><\/pre>\n<h3>\u5c0e\u5165\u65b9\u6cd5<\/h3>\n<ol>\n<li>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u65b0\u898f\u4f5c\u6210<\/li>\n<li>\u30c4\u30fc\u30eb\u30d0\u30fc &gt; \u62e1\u5f35\u6a5f\u80fd &gt; Apps Script \u3092\u958b\u304f<\/li>\n<li>\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u7de8\u96c6\u753b\u9762\u304c\u958b\u304f\u306e\u3067\u3001\u4e0a\u8a18\u30bd\u30fc\u30b9\u3092\u30da\u30fc\u30b9\u30c8\u3057\u3066\u4fdd\u5b58<\/li>\n<li>\u30b7\u30fc\u30c8\u306b\u623b\u308a\u3001\u95a2\u6570\u3092\u4f7f\u7528<\/li>\n<\/ol>\n<h3>\u95a2\u6570\u306e\u4f7f\u3044\u65b9<\/h3>\n<pre><code>=f7conv(\"\uff7d\uff70\uff8a\uff9f\uff70\uff76\uff98\uff8c\uff97\uff7c\uff9e\uff98\uff7d\uff83\uff68\uff6f\uff78\uff74\uff78\uff7d\uff8b\uff9f\uff71\uff98\uff84\uff9e\uff70\uff7c\uff6c\uff7d\")<\/code><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/hi3103.net\/notes\/img\/uploads\/2020\/05\/f7conv-1.png\" alt=\"f7conv\u95a2\u6570\u306e\u4f7f\u7528\u4f8b\" width=\"406\" height=\"80\" style=\"border:1px solid #CCC\" \/><\/p>\n<ul>\n<li>\u901a\u5e38\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u95a2\u6570\u3068\u540c\u69d8\u3001\u4e0a\u8a18\u306e\u3088\u3046\u306b\u5f15\u6570\u306b\u6587\u5b57\u5217\u3092\u6e21\u3059\u3002<\/li>\n<\/ul>\n<pre><code>=f7conv(A1)<\/code><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/hi3103.net\/notes\/img\/uploads\/2020\/05\/f7conv-2.png\" alt=\"f7conv\u95a2\u6570\u306e\u4f7f\u7528\u4f8b\" width=\"655\" height=\"85\" style=\"border:1px solid #CCC\" \/><\/p>\n<ul>\n<li>\u30bb\u30eb\u3092\u53c2\u7167\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3002<\/li>\n<\/ul>\n<h4>\u6ce8\u610f\u70b9<\/h4>\n<ul>\n<li>\u6e21\u3055\u308c\u305f\u6587\u5b57\u30921\u3064\u305a\u3064\u533a\u5207\u3063\u3066\u7f6e\u63db\u3059\u308b\u3001\u3068\u3044\u3046\u4ed5\u7d44\u307f\u4e0a\u3001\u5f15\u6570\u306b\u95a2\u6570\u3092\u6e21\u3059\u3053\u3068\u306f\u51fa\u6765\u306a\u3044\u3002<\/li>\n<\/ul>\n<pre><code>=f7conv(ASC(\"\u30b9\u30fc\u30d1\u30fc\u30ab\u30ea\u30d5\u30e9\u30b8\u30ea\u30b9\u30c6\u30a3\u30c3\u30af\u30a8\u30af\u30b9\u30d4\u30a2\u30ea\u30c9\u30fc\u30b7\u30e3\u30b9\"))<\/code><\/pre>\n<ul>\n<li>\u306a\u306e\u3067\u3001\u4e0a\u8a18\u306e\u3088\u3046\u306a\u66f8\u304d\u65b9\u3067\u306f\u52d5\u304b\u306a\u3044\u3002\n<ul>\n<li>\u4f8b\uff1a\u5168\u89d2\u30ab\u30bf\u30ab\u30ca\u3092<a href=\"https:\/\/support.google.com\/docs\/answer\/9061514?hl=ja\">ASC\u95a2\u6570<\/a>\u3067\u534a\u89d2\u30ab\u30bf\u30ab\u30ca\u306b\u5909\u63db\u3002\u66f4\u306bf7conv\u95a2\u6570\u3067\u5168\u89d2\u30ab\u30bf\u30ab\u30ca\u306b\u623b\u3059\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>\u53c2\u8003\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9<\/h3>\n<ul>\n<li>Google Apps Script\n<ul>\n<li><a href=\"https:\/\/developers.google.com\/apps-script\/guides\/sheets\/functions\">Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30ab\u30b9\u30bf\u30e0\u95a2\u6570 \u00a0|\u00a0 Apps Script \u00a0|\u00a0 Google Developers<\/a><\/li>\n<\/ul>\n<\/li>\n<li>JavaScript\n<ul>\n<li><a href=\"https:\/\/developer.mozilla.org\/ja\/docs\/Web\/JavaScript\/Guide\/Grammar_and_types\">\u6587\u6cd5\u3068\u30c7\u30fc\u30bf\u578b &#8211; JavaScript | MDN<\/a><\/li>\n<li><a href=\"https:\/\/developer.mozilla.org\/ja\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/undefined\">undefined &#8211; JavaScript | MDN<\/a><\/li>\n<li><a href=\"https:\/\/developer.mozilla.org\/ja\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/String\/split\">String.prototype.split() &#8211; JavaScript | MDN<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>\u66f4\u65b0\u5c65\u6b74<\/h3>\n<ul>\n<li>2022-10-29 \u30b3\u30e1\u30f3\u30c8\u3067\u306e\u6307\u6458\u3092\u53d7\u3051\u3066\u30bd\u30fc\u30b9\u3092\u66f4\u65b0\u3057\u307e\u3057\u305f\u3002\n<ul>\n<li>\u5f15\u7528\u7b26\u3092\u30b7\u30f3\u30b0\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u306b\u7d71\u4e00<\/li>\n<li><code>var<\/code> \u3092 <code>let<\/code> \u307e\u305f\u306f <code>const<\/code> \u306b\u66f8\u304d\u63db\u3048<\/li>\n<li>\u5f15\u6570\u306e\u30a8\u30e9\u30fc\u30c1\u30a7\u30c3\u30af\u3092\u8ffd\u52a0<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981 Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u3067\u300c\u534a\u89d2\u30ab\u30bf\u30ab\u30ca\u300d\u3092\u300c\u5168\u89d2\u30ab\u30bf\u30ab\u30ca\u300d\u306b\u5909\u63db\u3057\u305f\u304f\u306a\u3063\u305f\u3002 \u8272\u3005\u63a2\u3057\u305f\u304c\u3001\u5148\u4eba\u304c\u4f5c\u6210\u3057\u305f\u3082\u306e\u306f\u300c\u30ac\u300d\u306a\u3069\u306e\u6fc1\u97f3\u306e\u5909\u63db\u6642\u306b\u300c\u30ab\u300d\u3068\u300c\u6fc1\u70b9\u300d\u306b\u5206\u5272\u3055\u308c\u3066\u3057\u307e\u3044\u3001\u305d\u306e\u307e\u307e\u4f7f\u7528\u3067\u304d\u306a\u304b\u3063\u305f\u3002 \u4ee5 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[79],"tags":[92,36],"class_list":["post-1394","post","type-post","status-publish","format-standard","hentry","category-google","tag-google-app-script","tag-google-spreadsheet"],"_links":{"self":[{"href":"https:\/\/hi3103.net\/notes\/wp-json\/wp\/v2\/posts\/1394","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hi3103.net\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hi3103.net\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hi3103.net\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hi3103.net\/notes\/wp-json\/wp\/v2\/comments?post=1394"}],"version-history":[{"count":0,"href":"https:\/\/hi3103.net\/notes\/wp-json\/wp\/v2\/posts\/1394\/revisions"}],"wp:attachment":[{"href":"https:\/\/hi3103.net\/notes\/wp-json\/wp\/v2\/media?parent=1394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hi3103.net\/notes\/wp-json\/wp\/v2\/categories?post=1394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hi3103.net\/notes\/wp-json\/wp\/v2\/tags?post=1394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}