Syntax
URL_AUTHORITY(<URL string>)
Description
Gets the authority part of the URL provided as string.
Examples
| Column1 | URL_AUTHORITY returns |
|---|---|
=URL_AUTHORITY("http://user:password@sublevel.toplevel.root:80/path/file.ext?query=string#fragment") | user:password@sublevel.toplevel.root:80 |
=URL_AUTHORITY("http://admin:admin@1.3.root:70/path/file.ext?query=string#fragment") | admin:admin@1.3.root:70 |
=URL_AUTHORITY("http://robert:iguana@4.2.root:60/path/file.ext?query=string#fragment") returns "user:password@sublevel.toplevel.root:80" | robert:iguana@4.2.root:60 |