Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var fechaSE = "";
- var contador = 0;
- var sheetRT = getSheetSS('resulttotal');
- var dataRT = getDataSS('resulttotal');
- var sheetasp = getSheetSS('aspirantedlt');
- var dataasp = getDataSS('aspirantedlt');
- var Idborrar =[];
- var init = 0; for (var row = defaultIndex(); row < dataRT.length; row++){
- fechaSE = dataRT[row][10]; if ((dataRT[row][9]== 17) || ((dataRT[row][9]==15) && (isFechaDiff(fechaSE,120)) && (!dataRT[row][17]) && (!dataRT[row][18]))){
- Idborrar.push (dataRT[row][0]);
- contador++; }} contador = defaultIndex(); for (var ib = 0; ib <= Idborrar.length; ib++){
- var valorUF = sheetRT.getLastRow(); for (var x= contador; x < valorUF; x++ ){
- var valorAC= sheetRT.getRange(x,1).getValue();
- if(valorAC == Idborrar[ib]){
- sheetRT.deleteRow(x);
- contador= x-1;
- break;
- } } }
- for(var ib=0; ib<Idborrar.length; ib++){
- if (Idborrar.indexOf(Idborrar[ib])!== ib) Idborrar.splice(ib, 1);}
- Browser.msgBox(Idborrar.join("|")); init = defaultIndex(); Browser.msgBox(valorAC); for (var ib = 0; ib <= Idborrar.length; ib++){
- var valorUF = sheetasp.getLastRow(); for (var x= init; x < valorUF; x++ ){
- var valorAC= sheetasp.getRange(x,1).getValue();
- if(valorAC == Idborrar[ib]){
- sheetasp.deleteRow(x);
- init= x-1;
- break;
- }
- } }}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement