Dashboards & Visualizations

field extraction

sahana
Engager

Hi,

I need to extract a value  from a message field, which has multiple data values. as like below,

message:{user: xxxx,age:yy,gender:xxxx, position:"nnnn", place:yyy}

In the above i need to extract the position value, which may have n number datas present after this. So, I need to extract the position value by its name alone. 

And also this position value can be there with a name as designation also

 

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

From your example, the following rex should work

| rex "position:\"(?<position>[^\"]*)\""

Similarly for designation

Having said that, your example looks like it might be JSON but it not correctly formatted as JSON, so depending on what your actual data looks like, you may need to adjust the rex string

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...