Question

24

Insertion of brackets and quotation marks using Google Apps Script

rated 0 times [ 30] [ 6] / answers: 1 / hits: 16010 / 11 Years ago, fri, july 12, 2013, 12:00:00

I have recently started writing some scripts for Google Spreadsheets. I have no experience with Javascript though and I have question that is concerning a (as I suppose) basic issue.

I would like my script to insert data shown below into a cell in a sheet. How should I encode it to make it work?

komorkaLinku.setValue(=HYPERLINK(http://www.some.link/some/data+variable+something,something));

I had tried several ways but none of them worked.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

blaisep

Add To Favorites

Follow

Total Points: 748

Total Questions: 95

Total Answers: 108

Location: Federated States of Micronesia

Member since Sun, May 16, 2021

3 Years ago

blaisep questions

1 Change Center position of React leaflet map

Wed, Dec 16, 20, 00:00, 4 Years ago

1 Get JavaScript Map values as array?

Sun, Aug 16, 20, 00:00, 4 Years ago

1 How to do an inline for loop in JavaScript, that's not connected to a variable

Tue, Apr 7, 20, 00:00, 4 Years ago

1 How to write data to a file using Puppeteer?

Tue, Nov 12, 19, 00:00, 5 Years ago

1 Swiper coverflow effect not working as expected

Mon, Nov 11, 19, 00:00, 5 Years ago

View All

answered 11 Years ago zayne · Accepted Answer

You are trying to include quotes inside quoted text. There are a couple of ways to do that.

Use single quotes inside double quotes, or vice-versa.

komorkaLinku.setValue('=HYPERLINK(http://www.some.link/some/data'+variable+'something,something)');

Use escaped single quotes.

komorkaLinku.setValue('=HYPERLINK('http://www.some.link/some/data'+variable+''something','something')');

As @ScampMichael comments, it would be a better choice to use setFormula() in this case. You would still need to handle embedded quotes properly.