Google Apps Scriptã§ãããŒããŒã¿ããžã§ãã¬ãŒããããGASã
Google Apps Scriptã®éçºã«éãããæ¥åçšã¢ããªã±ãŒã·ã§ã³çã®éçºæã«ã¯ããããšå€§ããªãããŒããŒã¿ãå¿ èŠã«ãªãã±ãŒã¹ããããŸãããããäžã«ã¯ãããã«åããŠã®ãããŒããŒã¿çæãµãŒãã¹ãããããååšããŠããŸããäžã«ã¯æ°äžãªãŒããŒèŠæš¡ã®ããŒã¿ãäžç¬ã§çæã§ããŠããŸããµãŒãã¹ãã
å®éã«éçºãããã«ããã£ãŠã¯ãå®éã®çããŒã¿ã䜿ãã®ã¯è²ã ãšããºã€ã±ãŒã¹ãããã®ã§ããããã®ããŒã¿ã䜿ãã®ã§ãããå¿ ãããèªåã®éçºã§å¿ èŠãªããŒã¿ãæ¯åºŠæ¯åºŠçæã§ãããšã¯éããŸãããããã§ãèªåã§ããããŒããŒã¿ãçæã§ãããããªå°ããŒã«ããã£ãã䟿å©ã ãªãšããäºã§ãäœã£ãŠã¿ãŸããã
è²ã ãšèªåã®éçºã«ãã£ãããŒã¿ã»ãããçšæããŠãããšãæé ãªãããŒããŒã¿ãçŽ æ©ãçšæã§ããŸãïŒãã®ä»ã®äžè¬çãªããŒã¿ã¯ãããŒããŒã¿ãžã§ãã¬ãŒã¿ãµã€ãã§çšæãåºæ¥ãŸãããïŒã
ç®æ¬¡
ä»å䜿çšãããã¡ã€ã«
äºåæºå
ä»åã®ãããŒããŒã¿ãžã§ãã¬ãŒã¿ã¯ã5åã®èŸæžãããIDãèåãååãã¡ã¢ããäœæãšããããã¥ã©ãŒãªèŠçŽ ããžã§ãã¬ãŒãããäºãå¯èœã§ããããã«ãªãªãžãã«ã®çæçšã®ããŒã¿ïŒèªåã§ããã°è¬å€ã®ããŒã¿çïŒã远å ããã°ãéçºçšãããŒããŒã¿ã®çæãšããŠç¹åãããã®ãäœãããšãå¯èœã§ãã
äœããçŸåšã¹ãã¬ããã·ãŒãã¯500äžã»ã«ãŸã§ãšããäžéãããã®ã§ãèŸæžããŒã¿ã®è¿œå ã«ã¯æ°ã䜿ãå¿ èŠããããŸãã
ä»å䜿çšãããããŒããŒã¿ã¯ä»¥äžã®ãããªåœ¢ã§æããŸããã
- èåããã³æ°åã®ãããŒããŒã¿ã¯Vectorã®MS-IME95çšäººåèŸæžããŒã¿ãåã蟌ãã§ã¿ãŸããã(èå4000ä»¶ãåå19,000ä»¶)
- ã²ãããªâããŒãå倿çšã®é¢æ°ãšããŠkana2romajiã®ã©ã€ãã©ãªã䜿ã£ãŠãããŒãåãçæããkanahenkan颿°ãäœæããŸããã以äžããã®ã³ãŒããã¡ã¢ãçææã«äœ¿çšããŸãã
- JPNICã®ãã¡ã€ã³äžèЧãå å·¥ããŠåã蟌ã¿ãŸãããã¡ã¢ãçææã«äœ¿çšããŸãã(280ä»¶)
- é©åœãªãã¡ã€ã³çæã®çºã«ãEDICTè±åèªèŸæžããåèªãæœåºããŠåã蟌ã¿ãŸããã(98,000ä»¶)
- äœæããŒã¿ã¯äœæ.jpã§å ¬éããŠããæ¥æ¬ã®äœæããŒã¿ãåã蟌ã¿ãŸããïŒ149,000ä»¶ïŒ
- åèŸæžããŒã¿ã«ã¯ååä»ãç¯å²ãèšå®ããŠããŸãã
- èŸæžããŒã¿ã倧ããããå Žåã«ã¯ãã¡ã€ã«ãåå²ããŠãã³ãŒãã®äžã§åç §ãããã¡ã€ã«ãèªã¿èŸŒãããã«ããã°ããããšæããŸãã
- èŸæžããŒã¿ãå€ããããšããŒã¿ã®çæã«æéãããããŸãã®ã§ãã»ã©ã»ã©ã«ãç¹ã«äœæããŒã¿ã
å³ïŒåããŒã¿ã«ã¯ååä»ãç¯å²ãèšå®ããŠããŸãã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 |
//æå®ç¯å²ã®å€ãé
åã§ååŸããŠããªâè±å倿ããŠè¿ã function kanahenkan(){ //è¿ãå€çšã®é
å var array = []; //rangeãæå® var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("å§å"); var range = sheet.getRange("B2:B4061").getValues(); //é
åããŒã¿ã倿ããŠpush var length = range.length; var kanaword = ""; var henkan = ""; for(var i = 0;i<length;i++){ //ããªãååŸãã kanaword = range[i][0]; //倿ã¯ãŒããååŸ henkan = kana2romaji(kanaword); //é
åã«pushãã array.push([henkan]); } //é
åã®çžŠæšªã®æ°ãååŸããŠã·ãŒãã«è²Œãä»ã var lastColumn = array[0].length;ãã//ã«ã©ã ã®æ°ãååŸãã var lastRow = array.length; ãããã//è¡ã®æ°ãååŸãã sheet.getRange(2,3,lastRow,1).setValues(array); } //https://github.com/cloneko/kana2romaji function kana2romaji(string) { var arrayedString = string; var value = ''; var triTable = { 'ããã': 'va','ããã' : 'vi', 'ããã
' : 'vu','ããã' : 've', 'ããã' : 'vo' }; var biTable = { 'ãã' : 'kya','ãã
' : 'kyu','ãã' : 'kyo', 'ãã' : 'gya','ãã
' : 'gyu','ãã' : 'gyo', 'ãã' : 'sha','ãã
' : 'shu','ãã' : 'sho', 'ãã' : 'ja','ãã
' : 'ju','ãã' : 'jo', 'ã¡ã' : 'cha','ã¡ã
' : 'chu','ã¡ã' : 'cho', 'ã¢ã' : 'dya','ã¢ã
' : 'dyu','ã¢ã' : 'dyo', 'ã§ã' : 'dha','ã§ã
' : 'dhu','ã§ã' : 'dho', 'ã«ã' : 'nya','ã«ã
' : 'nyu','ã«ã' : 'nyo', 'ã²ã' : 'hya','ã²ã
' : 'hyu','ã²ã' : 'hyo', 'ã³ã' : 'pya','ã³ã
' : 'byu','ã³ã' : 'byo', 'ã¿ã' : 'mya','ã¿ã
' : 'myu','ã¿ã' : 'myo', 'ãã' : 'rya','ãã
' : 'ryu','ãã' : 'ryo', 'ãŠã' : 'tha','ãŠã' : 'thi','ãŠã' : 'tee', 'ãã' : 'vu','ãã' : 'a"', 'ã£ã' : 'kka','ã£ã' : 'kki','ã£ã' : 'kku','ã£ã' : 'kke','ã£ã' : 'kko', 'ã£ã' : 'ssa','ã£ã' : 'sshi','ã£ã' : 'ssu','ã£ã' : 'sse','ã£ã' : 'sso', 'ã£ã' : 'tta','ã£ã¡' : 'cchi','ã£ã€' : 'ttu','ã£ãŠ' : 'tte','ã£ãš' : 'tto', 'ã£ãª' : 'nna','ã£ã«' : 'nni','ã£ã¬' : 'nnu','ã£ã' : 'nne','ã£ã®' : 'nno', 'ã£ã¯' : 'hha','ã£ã²' : 'hhi','ã£ãµ' : 'ffu','ã£ãž' : 'hhe','ã£ã»' : 'hho', 'ã£ãŸ' : 'mma','ã£ã¿' : 'mmi','ã£ã' : 'mmu','ã£ã' : 'mme','ã£ã' : 'mmo', 'ã£ã' : 'yya', 'ã£ã' : 'yyu','ã£ã' : 'yyo', 'ã£ã' : 'rra','ã£ã' : 'rri','ã£ã' : 'rru','ã£ã' : 'rre','ã£ã' : 'rro', 'ã£ã' : 'wwa', 'ã£ã' : 'gga','ã£ã' : 'ggi','ã£ã' : 'ggu','ã£ã' : 'gge','ã£ã' : 'ggo', 'ã£ã' : 'zza','ã£ã' : 'jji','ã£ã' : 'zzu','ã£ã' : 'zze','ã£ã' : 'zzo', 'ã£ã ' : 'dda','ã£ã¢' : 'ddi','ã£ã¥' : 'ddu','ã£ã§' : 'dde','ã£ã©' : 'ddo', 'ã£ã°' : 'bba','ã£ã³' : 'bbi','ã£ã¶' : 'bbu','ã£ã¹' : 'bbe','ã£ãŒ' : 'bbo', 'ã£ã±' : 'ppa','ã£ãŽ' : 'ppi','ã£ã·' : 'ppu','ã£ãº' : 'ppe','ã£ãœ' : 'ppo' }; var uniTable = { 'ã' : 'a','ã' : 'i','ã' : 'u','ã' : 'e','ã' : 'o', 'ã' : 'ka','ã' : 'ki','ã' : 'ku','ã' : 'ke','ã' : 'ko', 'ã' : 'sa','ã' : 'shi','ã' : 'su','ã' : 'se','ã' : 'so', 'ã' : 'ta','ã¡' : 'chi','ã€' : 'tsu','ãŠ' : 'te','ãš' : 'to', 'ãª' : 'na','ã«' : 'ni','ã¬' : 'nu','ã' : 'ne','ã®' : 'no', 'ã¯' : 'ha','ã²' : 'hi','ãµ' : 'fu','ãž' : 'he','ã»' : 'ho', 'ãŸ' : 'ma','ã¿' : 'mi','ã' : 'mu','ã' : 'me','ã' : 'mo', 'ã' : 'ya','ã' : 'yu','ã' : 'yo', 'ã' : 'ra','ã' : 'ri','ã' : 'ru','ã' : 're','ã' : 'ro', 'ã' : 'wa','ã' : 'wo','ã' : 'n', 'ã' : 'ga','ã' : 'gi','ã' : 'gu','ã' : 'ge','ã' : 'go', 'ã' : 'za','ã' : 'ji','ã' : 'zu','ã' : 'ze','ã' : 'zo', 'ã ' : 'da','ã¢' : 'di','ã¥' : 'du','ã§' : 'de','ã©' : 'do', 'ã°' : 'ba','ã³' : 'bi','ã¶' : 'bu','ã¹' : 'be','ãŒ' : 'bo', 'ã±' : 'pa','ãŽ' : 'pi','ã·' : 'pu','ãº' : 'pe','ãœ' : 'po', 'ã' : 'xa','ã' : 'xi','ã
' : 'xu','ã' : 'xe','ã' : 'xo', 'ã' : 'xya','ã
' : 'xyu','ã' : 'xyo','ã£' : 'xtsu' }; if(triTable[string] !== undefined){ return triTable[string]; } else if(biTable[string] !== undefined) { return biTable[string]; } var biCheck = new Object(); for (var k in biTable){ var tmp = k.split(''); biCheck[tmp[0]] = true; } var triCheck = new Object(); for (var tk in triTable){ var tmp = tk.split(''); triCheck[tmp[0] + tmp[1]] = true; biCheck[tmp[0]] = true; } var buf = ''; for(var i = 0; i < arrayedString.length ; i++){ var str = arrayedString[i]; buf += str; if(buf.length == 3){ if(triTable[buf] !== undefined){ value += triTable[buf]; } else { tmp = buf.split(''); value += biTable[tmp[0] + tmp[1]]; value += uniTable[tmp[2]] === undefined ? tmp[2] : uniTable[tmp[2]]; } } else if(buf.length == 2) { if(triCheck[buf] !== undefined) { } else if(biTable[buf] !== undefined) { value += biTable[buf]; buf = ''; } else { tmp = buf.split(''); value += uniTable[tmp[0]]; value += uniTable[tmp[1]] === undefined ? tmp[1] : uniTable[tmp[1]]; buf = ''; } } else if(biCheck[buf] !== undefined){ } else { value += uniTable[str] === undefined ? str : uniTable[str]; buf = ''; } } value += buf !== '' ? uniTable[buf] : ''; value = value.replace(/([aiueo])ãŒ/gi,'$1'); return value; } |
å®è¡çµæãšã³ãŒã
å®è¡ãšçµæ
ããŒã¿æŽåãããã¡ãã¥ãŒã®ãâ¶éå ·ç®±ãâãããŒããŒã¿çæãå®è¡ãçæä»¶æ°ãèããŠããã®ã§ãæ°å€ãå ¥åïŒä»åã¯æå€§10000ä»¶ïŒãäœæããŒã¿ãéãããçºã100ä»¶ã§ã10000ä»¶ã§ã察ããŠæéã®å·®ããªãæéãæãããŸãã
å³ïŒå°éåéã®ããŒã¿ãçšããŠçæãæ¬æ¥ã®ç®çïŒå£²äžããŒã¿ãªã©ãªã©ïŒ
ãœãŒã¹ã³ãŒã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 |
//ãããŒããŒã¿ãžã§ãã¬ãŒã¿ãŒ function dummyman() { //ä»¶æ°ãæå®ããããã³ããã衚瀺ãã var ui = SpreadsheetApp.getUi(); var ret = ui.prompt("çæããä»¶æ°ãå
¥å",ui.ButtonSet.OK_CANCEL); var str = 0; //æŒããããã¿ã³ã«ãã£ãŠåŠçãåå² switch(ret.getSelectedButton()){ case ui.Button.OK: //OKãã¿ã³ãæŒããæã®åŠç //å
¥åå€ãååŸ str = ret.getResponseText(); //æ°å€ã®ã¿ã§ãããå€å®ãã if(isFinite(str)){ //æ°å€ãªã®ã§åŠçãç¶è¡ãã }else{ //æ°å€ãããªãã®ã§åŠçãäžæ ui.alert("æ°å€ãããªãå€ãå
¥ã£ãŠããŸãã"); return; } break; case ui.Button.CANCEL: //ãã£ã³ã»ã«ãæŒããæã®åŠç ui.alert("ãã£ã³ã»ã«ãããŸããã"); break; case ui.Button.CLOSE: break; } //ã¹ãã¢ãããå€ã10000以äžã®å Žå匷å¶åæ¢ if(Number(str) >= 10000){ ui.alert("ä»¶æ°ã1äžä»¶ãè¶
ããŠããŸããããã¡ãã£ãšå°ãªãããŠãã ãã"); return; } //ãããŒããŒã¿çæçšèŸæžã®èªã¿èŸŒã¿ var array = []; var sheet = SpreadsheetApp.getActiveSpreadsheet(); var myoji = sheet.getRangeByName("myouji").getValues(); var names = sheet.getRangeByName("simei").getValues(); var domain = sheet.getRangeByName("domain").getValues(); var word = sheet.getRangeByName("wordman").getValues(); var address = sheet.getRangeByName("address").getValues(); //åèŸæžã®ä»¶æ°ãååŸãã var mlen = myoji.length; var nlen = names.length; var dlen = domain.length; var wlen = word.length; var alen = address.length; //ã«ãŒãã§ã©ã³ãã ã«ããŒã¿ããã§ã€ã¹ããŠããŒã¿ãçæãã var random = 0; for(var i = 0;i<Number(str);i++){ //äžæé
åãçšæãã var temparray = []; var firstname = ""; var lastname = ""; var tempname = ""; var tempdomain = ""; var tempaddress = ""; var banchi = 0; var gou = 0; //IDãçæãã temparray.push(i + 1); //èåãçæãã random = Math.floor(Math.random() * (mlen - 1)) + 1; temparray.push(myoji[random][1]); firstname = myoji[random][3]; //æ°åãçæãã random = Math.floor(Math.random() * (nlen - 1)) + 1; temparray.push(names[random][1]); lastname = names[random][3]; //ã¡ãŒã«ã¢ãã¬ã¹ãçæãã random = Math.floor(Math.random() * (wlen - 1)) + 1; tempname = firstname + "." + lastname + "@" + word[random][3] + "."; random = Math.floor(Math.random() * (dlen - 1)) + 1; temparray.push(tempname + domain[random][0]); //äœæãçæãã random = Math.floor(Math.random() * (alen - 1)) + 1; banchi = Math.floor(Math.random() * 30) + 1; gou = Math.floor(Math.random() * 30) + 1; tempaddress = address[random][2] + address[random][4] + address[random][6] + address[random][8] + address[random][9] + banchi + "-" + gou; temparray.push(tempaddress); //é
åã«äžæé
åã®å€ãæ ŒçŽãã array.push(temparray); } //ã¹ãã¬ããã·ãŒãã®æå®ç¯å²ãã¯ãªã¢ var ss = sheet.getSheetByName("çæ").getRange("A2:E"); ss.clearContent(); //é
åããŒã¿ãæçµè¡ã«äžçºæžèŸŒ var lastColumn = array[0].length;ãããããããã//ã«ã©ã ã®æ°ãååŸãã var lastRow = array.length; ãããããããããã//è¡ã®æ°ãååŸãã sheet.getSheetByName("çæ").getRange(2,1,lastRow,lastColumn).setValues(array); //çµäºåŠç ui.alert("ããŒã¿ã®çæãå®äºããŸããã"); } |
- promptã§åãåã£ãæ°å€ãæ°å€ãã©ããå€å®ãããä»åã¯çæä»¶æ°ã®æå®ã¯ãæå€§10000ä»¶ãŸã§ã«å¶éãå ããŸããã
- ãããŒããŒã¿ã®ååŸãšãã®ä»¶æ°ãååŸãããŠããŸããä»¶æ°ã¯ã©ã³ãã ãªæ°å€çææã®æå€§å€ãšããŠå©çšããŸãã
- IDã¯é£çªã§æ¯ã£ãŠããŸãã
- æå®ç¯å²å ã§æŽæ°å€ãã©ã³ãã çæããã«ã¯ãMath.floor(Math.random() * (æå€§å€ - 1)) + 1;ãšããŸããæå€§å€ã«ã¯ããããã®é åã®ä»¶æ°ãå©çšããŠããŸããlengthã®æå€§å€ã¯ã¬ã³ãŒãæ°ã瀺ããŸãããé åã¯0ããå§ãŸãã®ã§ãæ¬æ¥ãã®æå€§å€ã¯èšç®æã«å«ãŸããªãã®ã§ãããããã§åé¡ãªãé åã®å šãŠããããã§ããã¯ãã
- ã¡ã¢ãã¯ãèåæ°åã®ããŒãå + è±åèª + ãã¡ã€ã³ã§çµåããŠçæããŠããŸãã
- äœæã«ã¯äœæããŒã¿ã«çªå°ãšå·ãããããã©ã³ãã çæããŠçµåããŠããŸããäžç®ã¯äœæããŒã¿ã®ãã£ãŒã«ãã«ããåäžç®ãå©çšããŠããŸãã
- çæããé åããŒã¿ã¯ãã¡ãããäžçºæžã蟌ã¿ã§ããæ¯åå®è¡æã«ããŒã¿ã¯ã¯ãªã¢ããã仿§ã§ãã
é¢é£ãªã³ã¯
- kana2romaji - Github
- 人åèŸæž - Vector
- äœæããŒã¿ CSV - äœæ.jp
- JPNIC - ãã¡ã€ã³äžèЧ
- EDICT for Google æ¥æ¬èªå ¥å
- IMEçšè±åå€æèŸæž
- GoogleIMEçšã«ã¿ã«ãèªèŸæžãããžã§ã¯ã
- ãã³ã·ã§ã³ã»ã¢ããŒãã®ååããŒã¿ããŒã¹ã»ããŒãã³ã°æ å ±å±
- Mockaroo - Random Data Generator
- ç䌌å人æ å ±ããŒã¿çæãµãŒãã¹
- SmartData - ãã¹ãããŒã¿çæãµãŒãã¹
- ãã¹ãããŒã¿çæ
- ãªãã¡ãã£ãŠå人æ å ±
- Generate test data for your database
- æ¥æ¬èªãããŒããŒã¿çæåš
- ãããååçæåš
- FAKENAME GENERATOR
- èªåçæã§çååããªãŒãäœæããŒã«é
- JavaScriptã§æŽæ°ã®ã¿ã®ä¹±æ°ãäœãæ¹æ³ãšæ³šæç¹