I created a business transaction to get the list of failed users in application.The splittings are in format IP;Country;City;UserId.I am getting the result as XX.XXX.XXX.XX;USA;Chicago;123546.Now i want IP,country,city,user id in separate columns in tables/chart.Is there any easy way to do this? .Please help me on this.
Answer by John J. ·
Thanks for the reply,can you please tell me where to add the regex expression?.If i add it,where i will be getting the split value,in my case city?.Based on this business transaction,i am going to create an incident(extended mail) to show the split values can you please help me on this as well?
Answer by James K. ·
Since it looks like these are pulled from a sensor, AppMon is going to look at this as one string. So I think the best option you have is instead of having one measure getting all of it, create a new measure off of that sensor for each of the sections and in each measure use a regular expression to only extract the piece that is relevant for that measure.
So for City you would have a measure named something like "City Measure" and regex pulling the value between the second and third semicolon. The measure you can use for this is Methods - Argument Value, it supports transformation regex.
EDIT: I'm always interested in regex, here is what it might look like for the case of City in my example above (capturing third piece):