Splunk Search

How to extract trailing numbers from a string with rex

hmbisht
Explorer

I'm trying to extract a string (alphabets and underscore) from a given string which can contain any number of numeric values in the end.

 rex field=_raw "type: (?.*)\d*$"

ex.
type: alphabets123 | alphabet
type: extract1 | extract
type: write_regex23| write_regex

0 Karma
1 Solution

Sukisen1981
Champion
| makeresults 
|  eval x="type: write_regex23" 
 | rex field=x "\:+(?<extract>.*?)\d+"

replace x by your source field and remove makeresults

View solution in original post

Sukisen1981
Champion
| makeresults 
|  eval x="type: write_regex23" 
 | rex field=x "\:+(?<extract>.*?)\d+"

replace x by your source field and remove makeresults

Sukisen1981
Champion

hi @hmbisht
Please accept the anser if it significantly helped resolve your issue or let us know if there are any more issues

0 Karma

hmbisht
Explorer

Thanks a lot @Sukisen1981

0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...