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

Popular posts from this blog

node.js - Node js - Trying to send POST request, but it is not loading javascript content -

javascript - Replicate keyboard event with html button -

javascript - Web audio api 5.1 surround example not working in firefox -