How to separate values in array by comma with Apps Script

Question

I am trying to get filter values in array, separated by comma in Apps Script. To illustrate, here is my function:

function filterReport(){
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var dataSheet = ss.getSheetByName('DATA');
 var emailds = getColumnNrByName(dataSheet, 'Email');
 var emailFilters = dataSheet.getRange(2, emailds, dataSheet.getLastRow() -1).getValues();

  for (var i = 0; i < emailFilters.length; i++) {

    var payload = JSON.stringify({
    'reportMetadata': {
    'reportFilters': [{  
      'value' : emailFilters[i][0],
      'column': 'EMAIL',
      'operator': 'equals' 
   }]
   }
    });

      Logger.log(payload)

}
 }

This is what I get:

[16-08-09 10:54:34:612 PDT] {"reportMetadata":{"reportFilters":[{"value”:”[email protected]","column":"EMAIL","operator":"equals"}]}}
[16-08-09 10:54:34:613 PDT] {"reportMetadata":{"reportFilters":[{"value":"[email protected]","column":"EMAIL","operator":"equals"}]}}
[16-08-09 10:54:34:613 PDT] {"reportMetadata":{"reportFilters":[{"value":"[email protected]","column":"EMAIL","operator":"equals"}]}}
[16-08-09 10:54:34:614 PDT] {"reportMetadata":{"reportFilters":[{"value":"[email protected]","column":"EMAIL","operator":"equals"}]}}

And I need:

{"reportMetadata":{"reportFilters":[{"value”:”[email protected], [email protected], [email protected], [email protected]","column":"EMAIL","operator":"equals"}]}}

Thanks!

M. A. Cordeiro · Accepted Answer · 2016-08-09 18:17:39Z

3

Have you already tried to use the split command ? By using this command you can turn a string into an array.

You can take a look at this link for mode details:

String.prototype.split()

answered Aug 9, 2016 at 18:17

M. A. Cordeiro

4798 silver badges14 bronze badges

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

3 Comments

Yulia Over a year ago

Closer! if I run var array = emailFilters.toString().split(","); I get

{"reportMetadata":{"reportFilters":[{"value”:[”[email protected], [email protected], [email protected], [email protected]”],”column":"EMAIL","operator":"equals"}]}}

. How do I remove '[ ]' after value?

Yulia Over a year ago

var array = emailFilters.toString().split(",").join(); worked

M. A. Cordeiro Over a year ago

I do recommend take a look at the website cited below. Actually you're dealing with json object and I think will be pretty interesting dig a little bit deeper about this subject. json.org/js.html

Tomerikoo · Accepted Answer · 2021-08-16 16:39:47Z

1

I used Cordeiro split with an array of emails from a sheet and it worked well.

I took a column of emails as an array and then use the split:

//Array
var EMAILS = emss.getRange(["C3:"+"C"+em_wlr]).getDisplayValues();
//Split
var emails_cs = EMAILS.toString().split(",").join();

Then I can use in the MailApp:

MailApp.sendEmail(emails_cs, templateSubject, templateText);

edited Aug 16, 2021 at 16:39

Tomerikoo

19.6k16 gold badges57 silver badges68 bronze badges

answered Aug 13, 2021 at 19:06

Max G

111 bronze badge

Collectives™ on Stack Overflow

How to separate values in array by comma with Apps Script

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related