topic Re: Feild extraction using regex in Splunk Search

Field extraction using regex

dinesh001kumar — Sun, 01 Sep 2024 19:34:35 GMT

Hi All,

Can anbody help us with the Regex expression to extract the feild of Channel: values will be either APP or Web which was highlighted in Sample logs below.

Sample Log1:

\\\":\\\"8E4B3815425627\\\",\\\"channel\\\":\\\"APP\\\"}\"","call_res_body":{},

Sample Log2:

4GksYUB7HGIfhfvs_iLtSc8EFCzOzbAJBze8wjXSDnwmgdhwjjxjsghqsxvhv\\\",\\\"channel\\\":\\\"web\\\"}\"","call_res_body":{},"additional_fields":{}}

Re: Feild extraction using regex

Thulasinathan_M — Sat, 31 Aug 2024 16:49:13 GMT

You can try something like below in rex command

channel[^A-Za-z]+(?<channel_type>[^\\]+)

Re: Feild extraction using regex

ITWhisperer — Sun, 01 Sep 2024 14:37:02 GMT

Firstly, this looks like it might be some sort of JSON, so you might be better of treating it as such.

However, if you wish to proceed with regex, then you could try something like this

| rex "channel[^\w]+(?<channel>APP|web)"

Re: Feild extraction using regex

PickleRick — Sun, 01 Sep 2024 17:52:47 GMT

Actually, it looks like some horribly disfigured json. It's twice escaped "->\"->\\\"

It might be smart to look into the ingestion process and try to optimize it.

Re: Feild extraction using regex

ITWhisperer — Sun, 01 Sep 2024 20:07:21 GMT

I agree with @PickleRick but sometimes this can be gotten around by reparsing fields with spath, but we can't tell this without seeing the full event.