| Excerpt |
|---|
This examples illustrates how you can extract component parts of a URL using |
...
specialized functions for the URL data type. |
Functions:
| D generate list excerpts | ||
|---|---|---|
|
Source:
Your dataset includes the following values for URLs:
...
When the above data is imported into the application, the column is recognized as a URL. All values are registered as valid, even the IPv4 numeric address.
To extract the domain and subdomain values:
...
| URL | urlParams | urlParam_q1 |
|---|---|---|
| www.example.com | ||
| example.com/support | ||
| http://www.example.com/products/ | ||
| http://1.2.3.4 | ||
| https://www.example.com/free-download | ||
| https://www.example.com/about-us/careers | ||
| www.app.example.com | ||
| www.some.app.example.com | ||
| some.app.example.com | ||
| some.example.com | ||
| example.com | ||
| http://www.example.com?q1=broken%20record | {"q1":"broken record"} | {"q1":"broken record"} |
| http://www.example.com?query=khakis&app=pants | {"query":"khakis","app":"pants"} | |
| http://www.example.com?q1=broken%20record&q2=broken%20tape&q3=broken%20wrist | {"q1":"broken record", "q2":"broken tape", "q3":"broken wrist"} | {"q1":"broken record"} |
| D s also | ||
|---|---|---|
|
