senyaitiya

SET CURRENT_DIR=%cd%
SET LOG_NAME=linecount.log
SET LOG_DIR=%CURRENT_DIR%¥%LOG_NAME%

rem バッチファイルのあるディレクトリに移動
cd %CURRENT_DIR%
rem テキストファイルの行数をログに出力
find /c /v "" *.txt > %LOG_DIR%

senyaitiya

UPDATE
	TABLE 
SET 
	no = TA_2.no　
FROM
	TABLE TA
INNER JOIN ( 
		SELECT 
			id
			,RANK() OVER (ORDER BY id) AS no

senyaitiya

function PlayList() {

  //シート定義
  const ss = SpreadsheetApp.getActiveSpreadsheet()
  const sheetName1 = "シート1";
  const srcSheet = ss.getSheetByName(sheetName1);

  //データを貼り付けるシートをクリア
  srcSheet.clear()

senyaitiya

function doPost(y) {
  var token = PropertiesService.getScriptProperties().getProperty("xoxp-123");
  var name = "name";
  
  var token = PropertiesService.getScriptProperties().getProperty('SLACK_ACCESS_TOKEN');
  var app = SlackApp.create(token);
  var spreadsheet = SpreadsheetApp.openById('sheetID');
  var sheet = spreadsheet.getSheetByName('シート1');
  
  var range = sheet.getRange("シート1!C1").setFormula('=INDIRECT("シート1!A:A" & INT(RAND()*n+1))');

senyaitiya

/*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 Botkit Basic Template for Heroku

 Author: okajax (https://github.com/okajax)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*/

//=========================================================
// Botの準備