Splunk Search

How to write the regex to extract numbers between two hyphens?

jhayIV
Engager

I have the following string 2016-02-17 field and I would like to extract the 02 between the hyphens. Does someone have a regex that will do this?

Tags (2)
0 Karma
1 Solution

vasildavid
Path Finder

Sure,

\d{4}-(?<month>\d{2})-\d{2}

Check out www.regex101.com It can help with building out/learning regular expressions.

View solution in original post

vasildavid
Path Finder

Sure,

\d{4}-(?<month>\d{2})-\d{2}

Check out www.regex101.com It can help with building out/learning regular expressions.

angelo_fazzina
Engager

is it this simple?

\-\d\d\-

\-  = escapes the 1st hyphen
\d\d  =  2 digits
\-  = escapes the 2nd hyphen

-ALF

0 Karma

jhayIV
Engager

Thank you so much I think I messed up the regex command in the search field
I entered the string below in the search field:

rex mode=sed"\d{4}-(?\d{2})-\d{2}"
0 Karma
Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...