My Google script is throwing an "Unexpected string error"

Question

I am filling an array with some formulas to write as part of a data moving script. This line throws "unexpected string" error from Google Script when I try to save it:

var forms = [[,"=\"Week Averages\"","=iferror(round(average(C"+startRow+":C"+endRow+"),1),)",,,,,,,
"=rept(char(9733),(round(arrayformula(sum(len(J"+startRow+":J"+endRow+")-len(SUBSTITUTE(J"+startRow+":J"+endRow+",char(9733),""))))/counta(J"+startRow+":J"+endRow+"))))&rept(char(9734),5-(round(arrayformula(sum(len(J"+startRow+":J"+endRow+")-len(SUBSTITUTE(J"+startRow+":J"+endRow+",char(9733),""))))/counta(J"+startRow+":J"+endRow+"))))",
"=rept(char(9733),(round(arrayformula(sum(len(K"+startRow+":K"+endRow+")-len(SUBSTITUTE(K"+startRow+":K"+endRow+",char(9733),""))))/counta(K"+startRow+":K"+endRow+"))))&rept(char(9734),5-(round(arrayformula(sum(len(K"+startRow+":K"+endRow+")-len(SUBSTITUTE(K"+startRow+":K"+endRow+",char(9733),""))))/counta(K"+startRow+":K"+endRow+"))))",
"=rept(char(9733),(round(arrayformula(sum(len(L"+startRow+":L"+endRow+")-len(SUBSTITUTE(L"+startRow+":L"+endRow+",char(9733),""))))/counta(L"+startRow+":L"+endRow+"))))&rept(char(9734),5-(round(arrayformula(sum(len(L"+startRow+":L"+endRow+")-len(SUBSTITUTE(L"+startRow+":L"+endRow+",char(9733),""))))/counta(L"+startRow+":L"+endRow+"))))",
"=rept(char(9733),(round(arrayformula(sum(len(M"+startRow+":M"+endRow+")-len(SUBSTITUTE(M"+startRow+":M"+endRow+",char(9733),""))))/counta(M"+startRow+":M"+endRow+"))))&rept(char(9734),5-(round(arrayformula(sum(len(M"+startRow+":M"+endRow+")-len(SUBSTITUTE(M"+startRow+":M"+endRow+",char(9733),""))))/counta(M"+startRow+":M"+endRow+"))))",
"=countif(N"+startRow+":N"+endRow+",\"=Yes\")/(countif(N"+startRow+":N"+endRow+",\"=Yes\")+countif(N"+startRow+":N"+endRow+",\"=No\"))",,,,,,,,]]

Can anyone help me see what I'm missing? I've tried removing different sections of it and can't seem to pinpoint the problem. Thank you!

Diego · Accepted Answer · 2020-11-29 18:00:14Z

1

You're getting an error because of the quotation marks "". You can:

escape the marks \"\"
use single quotes ' to delineate your strings endRow+',char(9733),""))))/counta(J'+startRow
use template literals (e.g. `${endRow},char(9733),""))))/counta(J${startRow}`)

answered Nov 29, 2020 at 18:00

Diego

9,5812 gold badges24 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

My Google script is throwing an "Unexpected string error"

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related