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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Unlocking Unified Insights: New Gigamon Federated Search App for Splunk

In today’s data-heavy environment, organizations are caught in a data distribution dilemma. As data volumes ...

GA: New Data Management App in Splunk Platform

Streamlining Data Management: Introducing a unified experience in Splunk Managing data at scale shouldn’t feel ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...