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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...