Hi all,
I'm new in using Log Parser 2.2, but i would like to split the data from cs-uri-query into separate variables for storing them as separtes values in a ms sql database. I've got for example:
s=1&tt=15&te=lt r&spd=1&npf=1&c id=69&d=300,250 &fid=8102
as value for cs-uri-query and would like to store the value 1 for s, 15 for tt etc etc in a new database. anyone can help me with this?
Any help is greatly appreciated.
(i know it has something to do with substring and charindex, but i cant figure it out...)
I'm new in using Log Parser 2.2, but i would like to split the data from cs-uri-query into separate variables for storing them as separtes values in a ms sql database. I've got for example:
s=1&tt=15&te=lt r&spd=1&npf=1&c id=69&d=300,250 &fid=8102
as value for cs-uri-query and would like to store the value 1 for s, 15 for tt etc etc in a new database. anyone can help me with this?
Any help is greatly appreciated.
(i know it has something to do with substring and charindex, but i cant figure it out...)
Comment