tanaike

The Thinker

Updated ggsrun to v134

ggsrun was updated to v.1.3.4 v1.3.4 (January 2, 2018) Added new option for downloading ‘bound-scripts’ of Google Sheets, Docs, or Forms file. When the bound-scripts are downloaded, the project name cannot be retrieved because Drive API cannot be used for the bound-scripts. So when the bound-scripts are downloaded, the project ID had been used previously. Such filename is not easily to be seen. By this additional option, users can give the filename when it downloads the bound-scripts.

Bitfinex API for Google Apps Script

Gists This sample script is converted this sample script (javascript) to Google Apps Script. The point for converting is signature as shown in the following sample script. At Bitfinex API, after "/api/" + apiPath + nonce + rawBody is encrypted using HMAC SHA-384, the data of byte array is converted to HEX. In Google Apps Script, there is no the method for this. The data which was encrypted by Utilities.

Splitting String by N Characters for Batch-file

Gists This sample script is for splitting string by N characters for batch-file. In this sample, after it retrieves N characters from the first character of STR, the N characters are removed from STR. This is repeated until the end of STR. Sample script : @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION SET "STR=ABCDEFGHIJKLMNOPQRSTUVWXYZ" REM Split STR by N characters SET "N=2" :LOOP SET "RES=%RES%!STR:~0,%N%! " SET "STR=!STR:~%N%!" IF DEFINED STR GOTO LOOP ECHO "%RES:~0,-1%" Result : N=2 "AB CD EF GH IJ KL MN OP QR ST UV WX YZ" N=5 "ABCDE FGHIJ KLMNO PQRST UVWXY Z" Reference : https://stackoverflow.