Splitting spreadsheet strings into array values [duplicate]

Question

I need to split a value from a cell into separate array values. I am taking a list of emails from my spreadsheet and need to use the addCommenters() method.

Spreadsheets cell value: [email protected], [email protected], [email protected] ... etc.

I need to split around the ", " properly to pass the array into addCommenters().

What is the programmatic way to do this?

The "duplicate" covers more than just splitting the string, I know. — Mogsdad
– Mogsdad, Commented Oct 26, 2015 at 18:37

JPV · Accepted Answer · 2015-10-23 07:02:11Z

4

If you get the value of that cell (using .getValue())

var emails = sheet.getRange(range_here).getValue()

and then apply the split() method

var commentersArray = emails.split(",")

you will have an array you can pass to the .addCommenters() method.

file.addCommenters(commentersArray);

answered Oct 23, 2015 at 7:02

JPV

27.4k4 gold badges37 silver badges50 bronze badges

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

3 Comments

MasterCrander Over a year ago

I wasn't sure if this would work because it doesn't show the drop-down menu for this method. Why does it not autocomplete like other methods?

JPV Over a year ago

Not sure. Maybe because it is not a 'pure' GAS method but rather a javaScript method ?

MasterCrander Over a year ago

That makes sense, it would be impractical to add all javascript in there. Can you please assist on my other question related to this same project?

Collectives™ on Stack Overflow

Splitting spreadsheet strings into array values [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related