Skip to content

Instantly share code, notes, and snippets.

View teramako's full-sized avatar

teramako teramako

81 followers · 0 following
View GitHub Profile
@teramako
teramako / join.vba
Created June 27, 2016 06:14
Excel VBAの標準モジュールに追加してる関数
' ="SELECT ..... FROM ... WHERE column_A in ("&join(A1:A10,",","'")&")" などと式に使うことを想定
' SQLインジェクション可能だが知らん。
Function join(r As Range, Optional delimiter As String = ",", Optional wrap As String = "'") As String
Dim i As Integer
Dim result = As String
result = wrap & r.Cells(1, 1).Value & wrap
For i = 2 To r.rows.Count
@teramako
teramako / gist:a076cedcaebcc70252bf
Last active August 29, 2015 14:17
今日ダウンロードしたzipファイル。
$ file HOGEHOGE.zip
HOGEHOGE.zip: Bourne-Again shell script text executable
$ strings HOGEHOGE.zip
#!/bin/bash
sed -e '1,/BIGIN HOGEHOGE/d' $0 |sed -e '1,/BIGIN HOGEHOGE/d' > ./test.tar.gz
tar zxvf test.tar.gz >/dev/null;
chown root aFile bFile cFile
chmod 4755 aFile bFile cFile
exit 0
#BIGIN HOGEHOGE
@teramako
teramako / es6_quiz_answer.md
Last active October 26, 2017 15:04

ECMAScript6th Quiz Answer

Answer of ES6 Quiz

A.1

  • 2 "func"

see: [9.2.12 SetFunctionName][9.2.12], [12.14.4 Runtime Semantics of AssignmentExpression][12.14.4]

@teramako
teramako / ES6_quiz.md
Last active August 20, 2018 01:46

ECMAScript6th Quiz

Q.1

let func = function() {};
func.name
  1. ""
  2. "func"
@teramako
teramako / list_found.js
Created January 19, 2015 13:10
Vimperator プラグイン。<Leader>/ でページ内検索した時にリストを作成して foundlist コマンドで該当箇所にジャンプする。
var wm = new WeakMap;
mappings.addUserMap([modes.NORMAL], ["<Leader>/"], "Search forward for a pattern", function () { openPrompt(modes.SEARCH_FORWARD); });
commands.addUserCommand(['foundlist', 'fl'], 'show found list',
function (args) {
var index = parseInt(args.literalArg, 10);
if (Number.isNaN(index))
return;
@teramako
teramako / fix_mime_desc.patch
Created March 23, 2014 03:10
Mac の QuickTime プラグイン部分（about:addons と about:plugins）が文字化けしているので修正するパッチ
# HG changeset patch
# Parent 573ef29c7a9f67205f71527db56d7f32500feffc
diff -r 573ef29c7a9f toolkit/mozapps/extensions/internal/PluginProvider.jsm
--- a/toolkit/mozapps/extensions/internal/PluginProvider.jsm Sat Mar 22 08:07:42 2014 -0700
+++ b/toolkit/mozapps/extensions/internal/PluginProvider.jsm Sun Mar 23 09:19:00 2014 +0900
@@ -408,7 +408,7 @@
for (let i = 0; i < mimeTypes.length; i++) {
let type = {};
type.type = mimeTypes[i];
@teramako
teramako / df.cmd
Last active August 29, 2015 13:56
Windows でディスク使用率等の一覧を表示する
@if(0)==(0) ECHO OFF
CScript //NoLogo //E:JScript "%~f0" %*
GOTO :EOF
@end
var COLUMN_INFOs = {
k: {
drive: { width: 5, align: "left" },
type: { width: 4, align: "left" },
total: { width: 14, align: "right" },
@teramako
teramako / lain.html
Created October 5, 2013 16:18
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Serial Experimental proceed</title>
<style>
#out { line-height: 1.5; }
#out > p { margin: 0; }
</style>
</head>
@teramako
teramako / proto_test.html
Created July 4, 2013 17:49
__proto__ のテスト
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>__proto__ test</title>
</head>
<body>
<h1>__proto__ test</h1>
<div id="out"></div>
@teramako
teramako / page-nav.js
Last active December 18, 2015 16:59 — forked from anonymous/page-nav.js
[Vimperator]ページ内の見出し的要素へジャンプする奴
"use strict";
/**
* :nav コマンドでテキトウに補完を使いましょう
* :nnoremap v :nav<Space> とかすると快適かも
*/
var selector = "h1, h2, h3, h4, main, [role=main], [role=navigation], [role=search]";
var cache = new WeakMap;
function getJumpList (force) {