Splunk Search

Sub a string until a specific character

Engager

Hello, I Need to know how can I trim a string from the begining until a specific character. For example, I have the the field data which contains emails so how can I trim the emails until "@" and let the rest in the field.

before: XXXXX@blabla.com
After:@babla.com

Thank you for your help 🙂

Tags (2)
0 Karma

Champion

Hi

Try like

| makeresults 
| eval email="XXXXX@blabla.com" 
| eval result = replace(email,"^[^\@]+","")

SplunkTrust
SplunkTrust

It's rex to the rescue. Try this.

... | rex mode=sed field=foo "s/[^@]+(@.*)/\1/" | ...
---
If this reply helps you, an upvote would be appreciated.
0 Karma