Extract user name from cookie
How can I do regex to get a106529 in this sample - string part of cookie? cookie name = ALN.ps.cache.key, then how should I do in regex rule to get "a106529" when I set up split measure for business transaction?
ALN.ps.cache.key=0AC23617-49AB-DE11-0147-81CF98938554|a106529|;
Hi Sharyl,
For the pattern shown above, the following should work for you:
.?\|([^\|]*)
Rob
Rob,
Thank you very much. I used $ to escap \ so I got result -. Is ? specific for dynaTrace?
Sharyl
Hi Sharyl,
No, the "?" isn't specific to dT. It's a "non-greedy" read in regex language. The backslash "\" is the escape character. The regex gets read this way:
- .?\| this means to "non-greedy" read to the first vertical bar "|". It's like .*\|, but .*\| will aggressively read to to the last vertical bar
- the ([^\|]*) will read up to the next vertical bar, and put that result into the return group. That's how we get the result.
Here's a screen shot of the "transformation regex" testing tool in dynaTrace showing the result:
Rob
Rob,
I think I have to split from header value. following are cookie string under request header. So I think I should use split by Header Value and Header Field = coookie. Now I have to work on new regex. Can you help?
User id is snvjjy03 from ALN.ps.cache.key=0A54D951-206B-DB59-0148-13C2FD6ADC75|snvjjy03|; in following header
AG-HS-PD-H-SESSION-ID=4_Fj6XA2CzmW1KyHmi91GvWeh0ntyQQgUKCUAWyZMDoReptKP0; BIGipServeragency-tam-primary-gl-443-pool=552736684.47873.0000; BIGipServeragency-tam-primary-ro-443-pool=635180716.47873.0000; dtCookie=9881DE4FC287DCA66EF85C70DB99930F|_default|1|eAgent|1; dtPC=585262618_830#Generic%20XHR; dtLatC=208|176.5|184.5|153.5|170|176|167|169|395|321.5|168; s_sess=%20s_cc%3Dtrue%3B%20SC_LINKS%3D%3B%20s_sq%3Dallstatetam%253D%252526pid%25253DGateway-Splash%252526pidt%25253D1%252526oid%25253Dhttps%2525253A%25252F%25252Fagencygateway2.allstate.com%25252FALLIANCE%25252Flaunch%25252F%2525253FSourceOfLaunchPoint%2525253D02%252526ot%25253DA%252526oi%25253D22%3B; BIGipServeragentsupport2-primary-443-pool=702289580.47873.0000; BIGipServereagent2-primary-443-pool=635180716.47873.0000; DCCD=dc2; USER_GEO_ID=TXG0201; s_vi=[CS]v1|29FF0111851D025F-4000010BC0000670[CE]; s_pers=%20gpv_pn%3D%252Faccessallstate%252Fanon%252Flogin.aspx%7C1409165780319%3B%20s_getNewRepeat%3D1409163980325-Repeat%7C1411755980325%3B; atgPlatoStop=1; LtpaToken2=34bst72C/hJNN603wBo0sWHyOGFMztZspmM/KyNEcxnvOvwe1aWMsQymY5o1TUkBmC4d42XtoEWaoPV9ioJj9XuTmw6Y1zLI87jPweav3DjKybWHoRHm5ZJhFvPYUi5+PNAHjDJlrxabW7TCwMm1weQB+CD7+xwJbYAOU4ggkjeQ+qy+nup5eBg6VIRcvsFY/CNBn0NT9g5x6eL+/x2qezsAu3pUIBls8XESMkNNfaa9lQ8rWrQ3Q+6GfsMO+GdCk1FANUNSU97uOAprNM0Dp5b9OVaSY9gtgiV7SVgdCwX1dVLuuqTTsJJ+mEe/TATqIf+F7OS399/IsQU4YvZKglQMHyOSMTh+3/JU4xFz8Bn8f0OF/K7z/PlxQgVRfTQRfnqkbeF+dWnByg/Ofy8ADqVgIPUUQhfA8fz2+0fGlSMU5MarUqD+hsbeXNdpjfwy3PfEl7Xiv8dTZnphRCud3qK+1IJwz6bfDpyZ/XedmEC2bs3o/EcxQkDcAqO/WZuL; LtpaToken=0KpCtg0Y4cxIXNIHGWy1d1LBN1JeEp5hXunmOd5+8/lnCCoxx+pcytqy4bXZc5TGg2fZORWORvDyLA/GpIdOcgOgDla2eKMpMiXd/qBiveArsosQDPDzXNkePkELqOQ1eyPxfdtkv2W1Fv2QdLbGlET3n1dR1vp5LgAXDdeUSzA7BO/r7qxqvD/oQQox3pIY88erA2zu9nzcs+S8LtfrtZmNX6BFiHc146cRmk99LpK53Gc6Ay8JrAGSujkE07oATmu/cWv2Z4TYhXe5mRZsD54yMPJ6b9uQA5ehHCmNo/Bdp+dz+UION4Rr9nFW+Cme48aMatlQkPMqFRZSpHJMLHu55EsdyCdwull/dNFoKYOdCx81ZyDY4bYq/DelLwk4CrZcoSWO5Ro=;ALN.ps.cache.key=0A54D951-206B-DB59-0148-13C2FD6ADC75|snvjjy03|; xaJSESSIONID=0000IzMvx-sw9aBTR8yMdPT4zRf:16h1943dc; TmznFfst=-420; CP=null*
This should work:
ALN.ps.cache.key=[^|]*\|([^|]*)
Welcome the
Dynatrace Community Forums
Check out the Forum User Guide and Forum Guidelines to learn how to get started.Community Member of the Month
August 2017
Announcing Dynatrace's Community Member of the Month for August 2017, Rick B.! Click here to read more! 
