Hot answers tagged

2

You have the basic concept right just piece it together step by step. This does the job: =REGEXREPLACE(JOIN(" ",ARRAYFORMULA(IFERROR( REGEXEXTRACT(SPLIT(A1," ",TRUE,TRUE), "https://example.com/(\S+)"),""))),"\s+"," ") You split the string at whitespaces, this is safe because URLs don't contain white space so you're definitely not breaking them up. This ...


1

From what I understand, as your browser, you must be using Google Chrome. Please follow these steps to create a custom engine for Google Chrome On your address bar, type chrome://settings/searchEngines Click on the Add button. A pop-up will appear. Choose a name for your custom engine Assign any keyword as in =sometext In the URL field place: {google:...


1

Check redirectnator Main purpose of the script is to check server code status but you can also look for the final url. Here's the code function redirectCheck(url, user, pwd) { try { function getResp(url, user, pwd){ var resp = UrlFetchApp.fetch(url, { muteHttpExceptions: true, followRedirects: false, headers: { ...


1

To follow on to the questions in comments on the answer from @jaycer : How do you create a file from a template inside a specific folder The URL would look like this https://docs.google.com/document/d/${temlpateId}/copy?id=${temlpateId}&copyCollaborators=false&copyComments=false&includeResolvedCommentsOnCopy=false&title=${title}&...


Only top voted, non community-wiki answers of a minimum length are eligible