How to copy a range to an array in Google Sheets Apps Script and delete array duplicates?

Question

I'm trying to avoid removing rows from sheets when copying and removing duplicates to another specified sheet.

In this case, the 'TestSheet' sheet is removing rows (The sheets need to stay static). I'd like to send the range to an array and manipulate the data there, and then add to another sheet (or export to csv eventually). Any help would be appreciated! Here's the code:

function copyNSavetest(){
  var ss = SpreadsheetApp.getActive();
  var scanSheetSheet = ss.getSheetByName('TestSheet');

  var scannedContents = [];
  var scannedContents = scanSheetSheet.getRange("A2:C500");
  Logger.log(scannedContents.getValues());

  scannedContents.removeDuplicates([1]);
  Logger.log(scannedContents.getValues());


}

Define a duplicate.

Cooper
– Cooper

2020-06-07 20:19:42 +00:00
Commented Jun 7, 2020 at 20:19 — Cooper
– Cooper, Commented Jun 7, 2020 at 20:19
The same cell text in the first column of the 3

Joel Bournival
– Joel Bournival

2020-06-07 20:36:42 +00:00
Commented Jun 7, 2020 at 20:36 — Joel Bournival
– Joel Bournival, Commented Jun 7, 2020 at 20:36

Cooper · Accepted Answer · 2020-06-07 20:43:53Z

1

function getUniqueArray(){
  const ss=SpreadsheetApp.getActive();
  const tsh=ss.getSheetByName('TestSheet');
  const tvs=tsh.getRange("A2:C500").getValues();
  let uA=[];
  let uB=[];
  tvs.forEach(function(r){
    let s=String(r[0]);
    if(uA.indexOf(s)==-1) {
      uA.push(s);
      uB.push(r);
    }
  });
  return uB;
}

answered Jun 7, 2020 at 20:43

Cooper

64.2k7 gold badges29 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to copy a range to an array in Google Sheets Apps Script and delete array duplicates?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related