Splunk Search

Regex to extract a field between 2 fixed words

marellasunil
Communicator

Hi,
I am having events,
Number1=ABCDAS Number2=10
Number1=hsd gdsf Number2=1
Number1=ADG FHK Number2=11
Number1=HGSF Number2=4

I would like to extract the field value of Number1, Field value does not displaying any value after space in Splunk fields.
Probably regex will help to extract ABCDAS, hsd gdsf, ADG FHK, HGSF
Could anybody help to extract?
Number1 & Number2 are constant fields...

Tags (2)
0 Karma
1 Solution

grijhwani
Motivator

Your question is not at all clear, presumably because English is not your first language, but as I understand it you are specifically referring to cases 2 and 3 in your example, where you have embedded spaces in the field value. Have you tried redefining the field using the interactive field extractor?

To extract interactively using a manual search you need something like the following to extract to a field name that you can then use:

 {search} | rex "Number1=(?<yourfield>.*) +Number2="

View solution in original post

grijhwani
Motivator

Your question is not at all clear, presumably because English is not your first language, but as I understand it you are specifically referring to cases 2 and 3 in your example, where you have embedded spaces in the field value. Have you tried redefining the field using the interactive field extractor?

To extract interactively using a manual search you need something like the following to extract to a field name that you can then use:

 {search} | rex "Number1=(?<yourfield>.*) +Number2="

marellasunil
Communicator

This is awesome, working exactly what I expected, Thank you very much grijhwani...

0 Karma
Get Updates on the Splunk Community!

What’s New & Next in Splunk SOAR

Security teams today are dealing with more alerts, more tools, and more pressure than ever.  Join us for an ...

Observability Unlocked: Kubernetes Monitoring with Splunk Observability Cloud

 Ready to master Kubernetes and cloud monitoring like the pros? Join Splunk’s Growth Engineering team for an ...

Update Your SOAR Apps for Python 3.13: What Community Developers Need to Know

To Community SOAR App Developers - we're reaching out with an important update regarding Python 3.9's ...