Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next
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
pagesDOMAIN Function,SUBDOMAIN Function,HOST Function,SUFFIX Function,URLPARAMS Function,FILTEROBJECT Function

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:

...

URLurlParamsurlParam_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
labelexample_domain_functions