URL_USERINFO

Syntax

URL_USERINFO(<URL string>)

Description

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

Examples

Column1URL_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