Splunk Search

How to edit my rex statement to extract the name out of this example string?

packet_hunter
Contributor

I am trying to rex out a person name out of the following....

.... @ xyz-2\\\\johndoe&........

Here is my current search:

sourcetype=A_cef_syslog category="ThisONe" | rex field=ThatONe "\@(?[\w+\d\-\\ ]+) " | stats list(person)

Ideally I would like the match to start with @ and stop at &...

Any help is much appreciated,

thank you!!!

0 Karma
1 Solution

sundareshr
Legend

Try this

... | rex field=ThatONe "@(?<name>[^\&]+)" | ...

View solution in original post

0 Karma

sundareshr
Legend

Try this

... | rex field=ThatONe "@(?<name>[^\&]+)" | ...
0 Karma

packet_hunter
Contributor

Thank you!!!

Lately I have been using online regex tester to test my rex code but apparently what works in the online tester doesn't always work... any other testing suggestions other than the obvious- "RTFM again" (which I am going to do)?

0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...