How to replace text by using Google scripts?

Question

I want to show an image from Google Drive in a Google Spreadsheet. I have to replace the text: open? for: uc?export=download& in the Shareable link: https://drive.google.com/open?id=0BwJUnx7uETDmaG42eGdEVUVocU0

I have tried this solution https://stackoverflow.com/a/42819032/2661411:

" I made a two lines script to use the share link of an image in Google Drive.

Go to Tools > Script editor.
Copy, paste the following code
Click on run for permission

function DRIVE_IMAGE(link){ prefix_url = "https://docs.google.com/uc?export=download&"; link.replace("open?", "uc?export=download&"); }

Using the script :

Copy the share link of your image in Google Drive.
Go to a cell
Enter the formula =IMAGE(DRIVE_IMAGE("COPIED_LINK")) "

But didn't work for me, it said:

TypeError: Cannot call method "replace" of undefined. (line 3, file "ImgView")

Any ideas? I would like it to keep it simple.

Ritesh Nair · Accepted Answer · 2017-07-28 19:11:20Z

2

You need to use https://docs.google.com/uc?export=download&id=<<IMAGE ID>>. Refer the below formula.

=image("https://docs.google.com/uc?export=download&id=0BwJUnx7uETDmaG42eGdEVUVocU0")

Script

/**
 * @customfunction
 */
function DRIVE_IMAGE(link){
   var newLink = link.replace("https://drive.google.com/open?", "https://docs.google.com/uc?export=download&");
   return newLink;
}

Now, you can use the formula =IMAGE(DRIVE_IMAGE("https://drive.google.com/open?id=0BwJUnx7uETDmaG42eGdEVUVocU0"))

edited Jul 28, 2017 at 19:11

answered Jul 28, 2017 at 18:51

Ritesh Nair

3,3651 gold badge19 silver badges26 bronze badges

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

3 Comments

isk27 Over a year ago

That is what I'm trying to do... but how? (I need a script)

Ritesh Nair Over a year ago

@isk27 I have added the script

isk27 Over a year ago

Is there any way to make a range selection? for example, I got a column with all the links to the images in the Drive and in the next column the formula that gets the correct link from the other column in the same row?

Collectives™ on Stack Overflow

How to replace text by using Google scripts?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related