Splunk Search

How to grep a number from a string?

nilotpaldutta
Explorer

Hi,

I have a column in my source with different severity levels, for example -

Severity

1 - High
2 - Medium
3 - Moderate
4 - Low
5 - Planning

From the query I need to extract only the numbers i.e. 1, 2 etc. I have tried some answers but haven't been able to get only the number.

.......| rex field=severity .severity=(?P<severity>\d+) | table severity

If anyone is aware kindly help.
Thanks in advance. Best regards.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Your regex string is good. The rex command syntax is incorrect. Try this:

...| rex field=severity "(?P<severity>\d+)" | table severity
---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Splunk Cloud | Empowering Splunk Administrators with Admin Config Service (ACS)

Greetings, Splunk Cloud Admins and Splunk enthusiasts! The Admin Configuration Service (ACS) team is excited ...

Tech Talk | One Log to Rule Them All

One log to rule them all: how you can centralize your troubleshooting with Splunk logs We know how important ...

Splunk Security Content for Threat Detection & Response, Q1 Roundup

Join Principal Threat Researcher, Michael Haag, as he walks through: An introduction to the Splunk Threat ...