How to get URL from text?

Question

Regular Expressions

Example - [URL= https://asjda;sjd;ajs.asdasdl/.edit#gid=0[/URL]
Required - https://asjda;sjd;ajs.asdasdl/.edit#gid=0
Please help
UPD :
so =REGEXEXTRACT(I7;"[URL=(^.*)]+") I get URL=

Answer 1

spoiler

At this time the Spreadsheet Service of Google Apps Script is not able to get the properties of cells rich text content, just the plain text by using getValue() method. Other methods like getFormula(), getNote() are able to get the corresponding cell property, but none of the them includes the URL of the link.

Source
Только вручную.

UPD: