adventurous1
Programmer
Hi...
I have some data that contains a column with a URL field. Within the URL field's contents, there are several values that I need to be able to parse out.
I can only do this with SQL (i.e. cant write a function since I dont have permissions to register/execute).
Can anyone help?
Thanks!
Example of URL field data
WT.tz=-6&WT.bh=17&WT.ul=en-us&WT.cd=32&WT.sr=1280x720&WT.jo=Yes&WT.ti=Veda%20Spa%20at%20Hotel%20Monaco%20in%20Denver,%20Colorado&WT.js=Yes&WT.jv=1.3&WT.ct=lan&WT.hp=0&WT.bs=1263x1773&WT.fv=10.0&WT.slv=Unknown&WT.tv=9.3.0&WT.sp=KC-DMN&WT.dl=0&WT.ssl=0&WT.es=
Example of final format/output of data
->One column for every WT parameter and its corresponding value
WT.tz WT.bh WT.ul WT.cd WT.sr WT.jo WT.TI
6 17 en-us 32 1280x720 Yes Veda Spa at Hotel Monaco in Denver,Colorado
I have some data that contains a column with a URL field. Within the URL field's contents, there are several values that I need to be able to parse out.
I can only do this with SQL (i.e. cant write a function since I dont have permissions to register/execute).
Can anyone help?
Thanks!
Example of URL field data
WT.tz=-6&WT.bh=17&WT.ul=en-us&WT.cd=32&WT.sr=1280x720&WT.jo=Yes&WT.ti=Veda%20Spa%20at%20Hotel%20Monaco%20in%20Denver,%20Colorado&WT.js=Yes&WT.jv=1.3&WT.ct=lan&WT.hp=0&WT.bs=1263x1773&WT.fv=10.0&WT.slv=Unknown&WT.tv=9.3.0&WT.sp=KC-DMN&WT.dl=0&WT.ssl=0&WT.es=
Example of final format/output of data
->One column for every WT parameter and its corresponding value
WT.tz WT.bh WT.ul WT.cd WT.sr WT.jo WT.TI
6 17 en-us 32 1280x720 Yes Veda Spa at Hotel Monaco in Denver,Colorado