Splunk Search

How to extract the field "user" from my data?

kiran331
Builder

Hi

How to extract the field "user" from the following data?

ABCDEFGHI\cw2343@ac.abcdefghi.com

ABCDEFGHI\kirann@ac.abcdefghi.com

ABCDEFGHI\12kirAN@ac.abcdefghi.com

I need to extract

user:
cw2343
kirann
12kirAN
0 Karma
1 Solution

sundareshr
Legend

Try this for rex

... | rex "\\(?<user>[^@]+)" | table user

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

\\(?<user>[^@]+)

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

richgalloway
SplunkTrust
SplunkTrust

Sundareshr beat me to it again.

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

sundareshr
Legend

Try this for rex

... | rex "\\(?<user>[^@]+)" | table user
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...

Index This | How many sevens are there between 1 and 100?

August 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...