Advertisement
mentoly

Remove Rows Based on Cell Values

Feb 17th, 2020
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.93 KB | None | 0 0
  1. // Deleting Rows Based on Cell Values
  2.  
  3. //GLOBALS
  4.  
  5. var SS = SpreadsheetApp.openById("1MGh6Mrod7T21ORrmaTOTWvjgi_6XhPv-ecUyL_MdoxE");
  6. var SHEET = SS.getSheetByName("cache");
  7. var RANGE = SHEET.getDataRange();
  8.  
  9.  
  10. var DELETE_VAL = "NO";
  11. var COL_TO_SEARCH = 11; //Zero is first
  12.  
  13. function main() {
  14.  
  15.   var startTime = new Date().getTime();
  16.  
  17.   var deleteSelectedRows = removeThenSetNewVals();
  18.  
  19.   var runTime = (new Date().getTime() - startTime)/1000;
  20.   Logger.log("Runtime is: "+runTime + " seconds");
  21. };
  22.  
  23. function removeNonMembers(){
  24.  
  25.   var rangeVals = RANGE.getValues();
  26.  
  27.   var newRangeVals = [];
  28.  
  29.   for(var i = 0; i < rangeVals.length; i++){
  30.     if(rangeVals[i][COL_TO_SEARCH] != DELETE_VAL){
  31.      
  32.       newRangeVals.push(rangeVals[i]);
  33.     };
  34.   };
  35.  
  36.   RANGE.clearContent();
  37.  
  38.   var newRange = SHEET.getRange(1,1,newRangeVals.length, newRangeVals[0].length);
  39.   newRange.setValues(newRangeVals);
  40. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement