Splunk Search

How to subtract a string from value field

anasshsa
Engager

I Need to know to subtract a string from the begining of a value until a specific character in Spl. For example, if I have a field who contains emails or another data:
MAIL FROM: YYYY@XXXXX.com BODY=7BIT
How to get just the email address YYYY@XXXXX.com
Thanks for the help.

Tags (3)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

This is very similar to your earlier question, but the example is different and so is the answer. This rex command will put the email address in the emailAddr field.

... | rex field=foo "(?<emailAddr>[^\s]+)" | ...
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...

Updated Data Management and AWS GDI Inventory in Splunk Observability

We’re making some changes to Data Management and Infrastructure Inventory for AWS. The Data Management page, ...