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) |
Argument | Required? | Data Type | Description |
---|---|---|---|
column_url | Y | string | Name of column or String or URL literal containing the host value to extract |
Name of the column or URL or String literal whose values are used to extract the host value.
Required? | Data Type | Example Value |
---|---|---|
Yes | String literal or column reference (URL) | http://www.example.com |