topic Getting information adjacent to a match. in Splunk Search

Getting information adjacent to a match.

jsven7 — Wed, 21 Oct 2015 13:21:24 GMT

Hello

Data example:

Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; MDDRJS)

I have to interpret the above MSIE 9.0 as IE 9. So far I've been able to find "MSIE" with this search:

| eval Browser=if(match(User_Agent,"(?i)MSIE"),"IE",User_Agent)

How do I extract only the "9.0" next to MSIE?

Re: Getting information adjacent to a match.

woodcock — Wed, 21 Oct 2015 13:52:18 GMT

Assuming that you have another field which contains the information, such as UA_Versoin, like this:

| eval Browser=if(match(User_Agent,"(?i)MSIE"),"IE",User_Agent . " " . UA_Version)

Re: Getting information adjacent to a match.

jsven7 — Tue, 29 Sep 2020 07:38:42 GMT

Oh a concatenation that's great! Now in order to put the version into the field UA_Version, how do I perform more than one action within the if statement when it is true? That way I can split the UA_Version within the same if statement.

Re: Getting information adjacent to a match.

woodcock — Wed, 21 Oct 2015 15:33:26 GMT

You can have multiple clauses like this;

if((((THIS) AND(THAT)) OR (SOMETHING)), "TrueText", "FalseText")

Re: Getting information adjacent to a match.

jsven7 — Wed, 21 Oct 2015 15:37:02 GMT

I love you. Thank you sir.