@echo off rem 本日 FOR /F "usebackq delims=" %%a in (`powershell "(get-date).ToString(\"yyyy/MM/dd\")"`) do Set TODAY=%%a echo %TODAY% rem 本日9時 setlocal set command=`powershell "[DateTime]::Today.AddHours(9).ToString('yyyy-MM-dd HH:mm:s…

chaika.hatenablog.com

<config.json> { "dbServer": "dmyServer", "database": "dmyDb", "user": "hogeUser", "password": "hogePassword", "timeout": 300, "url": "http:xxx.xxx.xx" } rem <execute.bat> echo off echo start execute.bat rem ======================================== rem [script 実行]</execute.bat></config.json>…

DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE select * from xxxxxx

# create test data try { $list = New-Object System.Collections.Generic.list[string]; $max = 300; for ($i = 1; $i -le $max; $i++) { $str = "key:$($i),value:$($i)" $list.Add($str) } $path = "./my-data.txt" $outFilePath = $ExecutionContext.Se…

anderson02.com

www.exceldemy.com

Dim okCount As Integer Dim ngCount As Integer Dim emptyCount As Integer okCount = WorksheetFunction.CountIf(Range("D9").CurrentRegion.Columns(2), "ok") ngCount = WorksheetFunction.CountIf(Range("D9").CurrentRegion.Columns(2), "ng") emptyCo…

kanegolabo.com webbibouroku.com

dekiru.net

tech.blog.aerie.jp

note.onichannn.net qiita.com

coliss.com 192.jp

d3js.org github.com observablehq.com wizardace.com uxbear.me press.monaca.io qiita.com kita-note.com

xtech.nikkei.com

atmarkit.itmedia.co.jp dev.classmethod.jp

# read file, output contents $list = @() foreach ($line in @(gc -path "./test-utf8.txt" -Encoding UTF8)) { $list += ($line + "_add") } # write file sc -path "./test-utf8-add-c.txt" -Encoding UTF8 -Value $list

# read file $lines = @(Get-Content -path "./test-utf8.txt" -Encoding UTF8) Write-Host $lines # output contents $list = @() foreach ($line in $lines) { $list += ($line + "_add") } # write file Set-Content -path "./test-utf8-add-b.txt" -Enco…

# encoding $enc = [System.Text.Encoding]::UTF8 # read file $lines = [System.IO.File]::ReadAllLines("./test-utf8.txt", $enc) # output contents $list = New-Object System.Collections.Generic.list[string] foreach ($line in $lines) { $list.Add(…

lig-log.com

atmarkit.itmedia.co.jp

developer.mozilla.org atmarkit.itmedia.co.jp numb86-tech.hatenablog.com zenn.dev

curl.se

yan-note.blogspot.com qiita.com

www.katalog.tokyo PowerQuery 同一組織コードの組織名をカンマ区切りで結合し1レコードにする方法 https://answers.microsoft.com/ja-jp/msoffice/forum/all/powerquery/f7e62416-8dc9-47df-8d54-21d07d54b6e3

Visual Studio 2022 ショートカット追加 ctrl + a: 編集.選択範囲を包括ブロックまで広げる ctrl + w: 編集.次の単語まで拡張 ctrl + 1: 前のメソッド ctrl + 2: 次のメソッド ctrl + 3: エディターコンテキストメニュー.ナビゲート.包含ブロックへ移動 Visu…

akabeko.me www.twilio.com ics.media

vuex.vuejs.org

uncle-javascript.com