How to breakdown Cookie information
I'm currently getting the Cookie information back from the server. Is there anyway to breakdown the information for individual use? i.e. |######|en_US|#######|CLIENT_XYZ, lets say I just wanted the Client's name. BC i created a BT that capture that Cookie information and it's working well, but it will make a better report/Dashboard if we could just get the Client's name.
Hi Mark,
Yes, you can do what you're looking for with the "Transformation Regex" that you'll see in the the BT measure definition. For your example above (|######|en_US|#######|CLIENT_XYZ), this would match and return CLIENT_XYZ:
|.*?|.*?|.*?|(.*)
If there was possibly more after CLIENT_XYZ, (such as |######|en_US|#######|CLIENT_XYZ|MoreStuff|EvenMoreStuff) then this would do it:
|.*?|.*?|.*?|([^|]*)
(Argh. The Wiki formatting is messing up my RegEx characters. Look at this image instead. Before every "pipe-char" above ("|"), there should be a blackslash ("\") )
Regards,
Rob
This pattern seems to work. |.?|.?|.?|([^|])
Its bringing back the just the Customer’s name
Yep, that would in fact do it. So one pattern solves all! Good luck with it.
Rob
I forgot to say Thanks for the all Help
My pleasure. The transformation regex was easy. The hard part was typing it into the forum editor!! :-)
