error in google sheets script: "TypeError: function split not found in object 0. (line16, file" SplitAuto ")." -
i have script worked before, few days, 1 no longer works .....
have error:
"typeerror: function split not found in object 0. (line16, file" splitauto ")."
can me please?
my script :
function splitalltest(){ var ss=spreadsheetapp.getactivespreadsheet(); var s=ss.getsheetbyname("réponses au formulaire 1"); var lr=s.getlastrow(); var lc=s.getlastcolumn()-8; //data columns num var range=s.getrange(1, 3, lr, lc).getvalues() var output=[]; var split=[]; var l = 0; // outout row count for(var i=0;i<range.length;i++){ //row roop // split column_data var split = []; var max1 = 0; for(var j=0;j<range[0].length;j++){ // column roop var colsplit = range[i][j].split(", "); split[j] = colsplit; if(max1 < split[j].length) max1 = split[j].length; } // push new rows data for(var k=0;k<max1;k++){ // max1 output [l] = []; for(var j=0;j<lc;j++){ // column if(k < split[j].length) { // if length 1 k 0 output[l].push(split[j][k]); // split [col_index][coldata_index] }else{ //output[l].push(''); change 2017/03/08 takashi output[l].push(j == 0 ? split[j][0]: ''); //only first name filled on each associated line }} l++; }} ss.getsheetbyname("temp formulaire").clear().getrange(1, 2, output.length,lc).setvalues(output); }
Comments
Post a Comment