Splunk Search

How do I write the regex to extract the date portion of this search result?

stocksltd
New Member

I'm new to the Splunk community. I'm trying to extract the date portion of this search result

M91040FA7104_Tue Jan 26 14:12:15 CST 2016

so everything after the _. I have been banging on this for 4 hours and can't seem to get it to produce anything.

0 Karma
1 Solution

somesoni2
Revered Legend

How about this

your base search | rex field=YourFieldName "_(?<YourDateField>\w+\s+\w+\s+\d+\s+\d+:\d+:\d+\s+\w+\s+\d+)$" | eval YourDateFieldInEpoch=strptime(YourDateField,"%a %b %d %H:%M:%S %Z %Y")

View solution in original post

somesoni2
Revered Legend

How about this

your base search | rex field=YourFieldName "_(?<YourDateField>\w+\s+\w+\s+\d+\s+\d+:\d+:\d+\s+\w+\s+\d+)$" | eval YourDateFieldInEpoch=strptime(YourDateField,"%a %b %d %H:%M:%S %Z %Y")
Get Updates on the Splunk Community!

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...