Extract URLs from Hyperlinks
=GetUrl(A2:A6)
function GetURL(input) {
var myFormula = SpreadsheetApp.getActiveRange().getFormula();
var myAddress = myFormula.replace(/=.*?\(/,'').replace(')','');
var myRange = SpreadsheetApp.getActiveSheet().getRange(myAddress);
var richTextValues = myRange.getRichTextValue().getRuns();
var urls = [];
for (var i = 0 ; i < richTextValues.length; i++) {
var url = richTextValues[i].getLinkUrl();
if (url) {
urls.push(url);
}
}
return [urls];
};
0 comments:
Post a Comment