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!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...