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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...