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

...

D code

derive type:single value: FILTEROBJECT(urlParams,'q1') as: 'urlParam_q1'

 

Results:

Column set 1:

URLhost_URLpath_URLprotocol_URLsubdomain_URLdomain_URLsuffix_URLurlParamsurlParam_q1
www.example.comwww.example.com  wwwexamplecom  
example.com/supportexample.com/support  examplecom  
http://www.example.com/products/www.example.com/products/http://wwwexamplecom  
http://1.2.3.41.2.3.4 http://     
https://www.example.com/free-downloadwww.example.com/free-downloadhttps://wwwexamplecom  
https://www.example.com/about-us/careerswww.example.com/about-us/careershttps://
www.app.example.comwww.app.example.com  
www.some.app.example.comwww.some.app.example.com  
wwwsome.app.example.comsome.app.example.com  
www.some.app.example.comwww.some.app.example.com  
wwwexample.some.appcomexample.com  
some.apphttp://www.example.com?q1=broken%20recordsomewww.app.example.com  some.appexamplehttp://
http://www.example.com?query=khakis&app=pantswww.example.com  somehttp://
http://www.example.comsome.example.?q1=broken%20record&q2=broken%20tape&q3=broken%20wristwww.example.com http://

Column set 2:

subdomain_URLdomain_URLsuffix_URLurlParamsurlParam_q1
wwwexamplecom  
some
 examplecom  
wwwexample
.comexample.
com  
     
wwwexamplecom  
 
wwwexamplecom  
http://
www.appexample
.com?q1=broken%20record
com  
www.some.appexamplecom  
some.appexamplecom  
someexamplecom 
http://
 
 examplecom  
wwwexamplecom{"q1":"broken record"}{"q1":"broken record"}
http://www.example.com?query=khakis&app=pantswww.example.com http://
wwwexamplecom{"query":"khakis","app":"pants"}
 http://www.example.com?q1=broken%20record&q2=broken%20tape&q3=broken%20wrist
www.example.com
 
http://
wwwexamplecom{"q1":"broken record", "q2":"broken tape", "q3":"broken wrist"}{"q1":"broken record"}