Splunk Search

Extract id from string using rex

rockts89
Engager

Hi all

How to extract id from String using rex?

sample:

sample-3456-777-text

result:

id
3456-777

Tags (2)
0 Karma
1 Solution

vnravikumar
Champion

Hi

Try like

| makeresults 
| eval text="sample-3456-777-text" 
| rex field=text "-(?P<id>\d+\-\d+)-"

View solution in original post

renjith_nair
Legend

@rockts89 ,

Try

\w+-(?<id>[\d-]+)-\w+

Please provide more samples if you have other patterns

---
What goes around comes around. If it helps, hit it with Karma 🙂

vnravikumar
Champion

Hi

Try like

| makeresults 
| eval text="sample-3456-777-text" 
| rex field=text "-(?P<id>\d+\-\d+)-"
Get Updates on the Splunk Community!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...