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.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...