URL_USERINFO

Syntax

URL_USERINFO(<URL string>)

Gets the user info part of the URL provided as string.

Column1	URL_USERINFO returns
http://user:password@sublevel.toplevel.root:80/path/file.ext?query=string#fragment	user:password
http://myaccess:mysecret@example.com/index.shtml	myaccess:mysecret