Splunk Search

Why am I unable to extract this field with my current rex statement?

jmaple
Communicator

I have a regex that should be extracting the employeeType field from an event. Below is the text of the event and the regex I am using.

Details:  
    Attributes:
        employeeType
            Contractor

Search:

mysearch | rex "employeeType\n\t\t\t(?<employeeType>\w+)"

We see the extraction work on regxr, but it doesn't seem to extract in the search.

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Try ... | rex "employeeType\s*(?<employeeType>\w+)".

---
If this reply helps you, Karma would be appreciated.

View solution in original post

jbailey_splunk
Splunk Employee
Splunk Employee

Are you sure there are tabs preceding the "employeeType" value? Here's a few suggestions to try:

employeeType\n\t+(?\w+)

If there are tabs prior to the employeeType value, this should account for 1 or more tabs in the regex

employeeType\n\s+(?\w+)

If these are actually spaces, this should work

employeeType\s+(?\w+)

In my quick testing on https://regex101.com, I observed the regex did not need the newline token (\n) - so you could try your regex without it

Hope this helps,
Jamie

0 Karma

jmaple
Communicator

The raw value did not have the newline like the event appears to in the search which is why it worked in my testing because I was using the formatting presented with the search. In any case, richgalloway solved my issue. Thanks for replying!

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Try ... | rex "employeeType\s*(?<employeeType>\w+)".

---
If this reply helps you, Karma would be appreciated.

jmaple
Communicator

Well now don't I feel silly... Thanks.

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.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 ...