Splunk Search

How to extract a string from _raw?

avadhutha
Explorer

I have a string like below and unable to extract accuratly with rex command please suggest  any alternative way.

_raw----------------

{lable:harish,message: Say something, location:India, state:TS,qual:xyz}

{message: say nothing,lable:harish, location:India, state:TS,qual:xyz}

{lable:harish, location:India, state:TS,qual:xyz,message: say splunk splunk answers}

 

The message value is randomized location and I need to pick the message value.

 

When I try with below command it is not considering the proper end position. Please suggest

|rex "message:(?<Message_value>.*)[,|}]" |table Message_Value

Labels (2)
Tags (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Field names are case-sensitive, also, you are using a greedy match which may pick up more than you bargained for - try this

|rex "message:(?<Message_Value>.*?)[,|}]" |table Message_Value

 

View solution in original post

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Field names are case-sensitive, also, you are using a greedy match which may pick up more than you bargained for - try this

|rex "message:(?<Message_Value>.*?)[,|}]" |table Message_Value

 

0 Karma

avadhutha
Explorer

Thank you so much.., I was trying a lot of thing like field extraction and regex and you helped it well with ?.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...