Google Script Regex Returns Partial/Repeat Result

Question

I'm trying to use Google Script pull any number of URLs from a chunk of text in a Google spreadsheet cell.

My current script seems to log the same URL twice despite there being additional URLs. The same regex seems to work fine in the regex101 validator. The script I'm using is below and the logged response on the same content seen in the regex101 example is [http://dianeravitch.net/, dianeravitch.net/].

 function findURL() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[1];
  var range = sheet.getRange(4,3);
  var entry = range.getValue();
  var regExp = new RegExp("https?:\/\/([^\"]*)", "gmi"); 
var urlsFound = regExp.exec(entry);
Logger.log(urlsFound); 
}

Kriggs · Accepted Answer · 2015-10-13 19:54:25Z

1

It isn't capturing twice, the second value of the array is missing the HTTP, which is outside the the capturing group, the first result in the array is the whole matched value, while the second is the first (and only in this case) capturing group value.

To get all values you need to keep executing the regex until the end of string, as so:

var regExp = new RegExp("https?:\/\/([^\"]*)", "gmi"), urlsFound; 
while( urlsFound = regExp.exec(entry) ) Logger.log( urlsFound[1] );

answered Oct 13, 2015 at 19:54

Kriggs

3,7761 gold badge19 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Google Script Regex Returns Partial/Repeat Result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related