| Excerpt |
|---|
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:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: host('http://www.example.com' ) as: 'myHost' |
|---|
|
host('http://www.example.com') |
Output: Returns the value www.example.com.
Column reference example:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: host(myURLs) as: 'myHost' |
|---|
|
host(myURLs) |
Output: Returns the host values extracted from the myURLs column.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: host(column_url) |
|---|
|
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 |
column_url
Name of the column or URL or String literal whose values are used to extract the host value.
- Missing input values generate missing results.
- Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | String literal or column reference (URL) | http://www.example.com |
Example - Domain, Host, Subdomain, and Suffix functions
| Include Page |
|---|
| EXAMPLE - Domain Functions |
|---|
| EXAMPLE - Domain Functions |
|---|
|
