Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. var fechaSE = "";
  2. var contador = 0;
  3. var sheetRT = getSheetSS('resulttotal');
  4. var dataRT = getDataSS('resulttotal');
  5. var sheetasp = getSheetSS('aspirantedlt');
  6. var dataasp = getDataSS('aspirantedlt');
  7. var Idborrar =[];
  8. var init = 0; for (var row = defaultIndex(); row < dataRT.length; row++){
  9. fechaSE = dataRT[row][10]; if ((dataRT[row][9]== 17) || ((dataRT[row][9]==15) && (isFechaDiff(fechaSE,120)) && (!dataRT[row][17]) && (!dataRT[row][18]))){
  10. Idborrar.push (dataRT[row][0]);
  11. contador++; }} contador = defaultIndex(); for (var ib = 0; ib <= Idborrar.length; ib++){
  12. var valorUF = sheetRT.getLastRow(); for (var x= contador; x < valorUF; x++ ){
  13. var valorAC= sheetRT.getRange(x,1).getValue();
  14. if(valorAC == Idborrar[ib]){
  15. sheetRT.deleteRow(x);
  16. contador= x-1;
  17. break;
  18. } } }
  19.  
  20. for(var ib=0; ib<Idborrar.length; ib++){
  21. if (Idborrar.indexOf(Idborrar[ib])!== ib) Idborrar.splice(ib, 1);}
  22.  
  23. Browser.msgBox(Idborrar.join("|")); init = defaultIndex(); Browser.msgBox(valorAC); for (var ib = 0; ib <= Idborrar.length; ib++){
  24. var valorUF = sheetasp.getLastRow(); for (var x= init; x < valorUF; x++ ){
  25. var valorAC= sheetasp.getRange(x,1).getValue();
  26. if(valorAC == Idborrar[ib]){
  27. sheetasp.deleteRow(x);
  28. init= x-1;
  29. break;
  30. }
  31. } }}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement