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