topic Re: How to use rex command to extract this field from my sample log? in Splunk Search

How to use rex command to extract this field from my sample log?

Abilan1 — Wed, 26 Aug 2015 22:53:34 GMT

Hi ,

COSE#1017 Associated kernel not found. Please see Enterprise Server log for details: SocID:19041 PID:13695 BSFN:CustomShipConfirmWrapper user:AIAINBND

I want to create that highlighted term as a new event field. It may vary in length in following events. Could anyone help me?

Thanks

Re: How to use rex command to extract this field from my sample log?

MuS — Wed, 26 Aug 2015 23:10:38 GMT

Hi Abilan1,

try something like this, which is based on your provided example:

your base search here | rex "\sBSFN:(?<myField>[^\s]*)" | table myField

cheers, MuS

Re: How to use rex command to extract this field from my sample log?

Richfez — Wed, 26 Aug 2015 23:16:42 GMT

If BSFN is a constant, which it appears to be, something as simple as

 ... | rex "BSFN:(?<GiveMeAName>\w+)"

That says

BSFN: Match the string "BSFN:" (including the colon)

(? Then extract a field named "GiveMeAName"

\w+ Which consists of one or more "word" type characters (letters)

) And finally close off this extraction.

Re: How to use rex command to extract this field from my sample log?

Abilan1 — Wed, 26 Aug 2015 23:21:02 GMT

Thank You MuS!!

Re: How to use rex command to extract this field from my sample log?

Abilan1 — Wed, 26 Aug 2015 23:21:55 GMT

Thank You rich!!! it worked