Splunk Enterprise

how to eliminate the required values in field

james_n
Path Finder

Hi Experts,

Please help with regex to  parse the hh:mm:ss into separate filed as show below.

message:

hello this is the first message from splunk 12:45:13
hai this is the second message from splunk 
hello this is the third message from splunk 19:43:53

expected outpout:

 

subject:                                                                                                        time:
hello this is the first message from splunk                              12:45:13
hai this is the second message from splunk 
hello this is the third message from splunk                              19:43:53

| rex field=message "(?<subject>.\w+)\s*(?<time>.\d+:\d+:\d+)?" but not worked. plz help thanks in advance.

Labels (2)
0 Karma

bowesmana
SplunkTrust
SplunkTrust

@james_n 

This will work for your example, but not sure if it will work for all your data

| rex field=message "(?<subject>.*) (?<time>\d+:\d+:\d+)?"

 

0 Karma

to4kawa
Ultra Champion

please rex separately.

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, ...