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!

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...