Splunk Search

How to filter number from text with regular expression

dabroma5
Explorer

Hi,

I have two types of messages, I would like to receive the numbers from these logs :

2020-03-16 15:12:15,304 services/text123456: Periodic connection check - 1659 active services!
2020-03-16 15:11:56,173 services/textabcdef: NUMBER OF ACTIVE services: 1123

Thanks for help

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

This regex works with your examples. (?:check - |services: )(?<services>\d+)

---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

rmmiller
Contributor

As a first cut, add these lines to the end of your current search:

| rex field=_raw "Periodic\sconnection\scheck\s\-\s(?<num_active_svcs_chkd>\d+)\sactive\sservices"
| rex field=_raw "NUMBER\sOF\sACTIVE\sservices\:\s(?<num_active_svcs>\d+)"

This will give you 2 new fields, num_active_svcs_chkd and num_active_svcs. Theses names are completely arbitrary -- you can change them to suit your needs.

Once you're happy with how these extractions are going, work with your Splunk admin to get these added into props.conf.

Hope that helps!
rmmiller

0 Karma

richgalloway
SplunkTrust
SplunkTrust

This regex works with your examples. (?:check - |services: )(?<services>\d+)

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...

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

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...