Finds the host value from a valid URL. Input values must be of URL or String type and can be literals or column references.

In this implementation, a host value includes everything from the end of the protocol identifier (if present) to the end of the extension (e.g. .com).

URL literal examples:

host('http://www.example.com')


Output:
Returns the value www.example.com

Column reference example:

host(myURLs)

Output: Returns the host values extracted from the myURLs column. 

host(column_url)


ArgumentRequired?Data TypeDescription
column_urlYstringName of column or String or URL literal containing the host value to extract

column_url

Name of the column or URL or String literal whose values are used to extract the host value.

 

Required?Data TypeExample Value
YesString literal or column reference (URL)http://www.example.com

Example - Domain, Host, Subdomain, and Suffix functions