split cs-uri-query with logparser

Question posted by: Hollandski (Newbie) on May 28th, 2008 08:04 PM

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=ltr&spd=1&npf=1&cid=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...)

Not the answer you were looking for? Post your question . . .
189,170 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).