January 26, 2017
Google App Scripts 内置常用函数 custom functions (字符串,翻译,日期,搜索,复制模板,getRang,getSheetValues等)
1. google apps script string replace 文本代替
var FILE = SpreadsheetApp.openById("xyz");
var CONTENT = FILE.getSheetByName("Sheet1");
var A1 = CONTENT.getRange("I17").getValue();
var A1String = A1.toString().replace(".", "");
2. google apps script string split 文本分割成数组
function myFunction() {
var array1 = splitTest();
Logger.log(array1);
}
fu… Read More