URL_AUTHORITY

Owned by Juliane Wetzel
Last updated: May 10, 2023 by Konsta Danyliuk (Deactivated)

Syntax

URL_AUTHORITY(<URL string>)

Description

Gets the authority part of the URL provided as string.

Examples

Column1URL_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