Reporting

Convert Name to Email

Becherer
Explorer

I am looking to convert a field labeled "name" to populate email.

I am wanting to have a search that takes a name in a field and formats it to match our certain naming convention.

If the field has a name of Jim Smith, I want a second field to covert the name of Jim Smith to Jim.Smith@domain.com

I am looking to replace the space between the first and last name with a "." and add @domain.com after the lastname.

What the best way about going about this?

Labels (2)
0 Karma
1 Solution

nickhills
Ultra Champion

There are lots of edge cases that can break this but try:

 

| makeresults 
| eval name="Jim Smith" 
| rex field=name "(?P<firstName>\w+)\s(?P<surName>\w+)" 
| eval email=firstName.".".surName."@yourdomain.com"

 

 

If my comment helps, please give it a thumbs up!

View solution in original post

0 Karma

Becherer
Explorer

@nickhills 

One more thing- There is a second group of names that have a "name\Jim.Smith".

Is there a way to remove the "name\" and add @domain.com after. There is no need to add a "." for this group because it's already added.

 

Just didn't know if it's possible to have what you sent over to look for two possibilities. 

 

Thank you for your help! The first one worked, now I am just wanting to capture the remaining 20%.

0 Karma

nickhills
Ultra Champion

There are lots of edge cases that can break this but try:

 

| makeresults 
| eval name="Jim Smith" 
| rex field=name "(?P<firstName>\w+)\s(?P<surName>\w+)" 
| eval email=firstName.".".surName."@yourdomain.com"

 

 

If my comment helps, please give it a thumbs up!
0 Karma
Get Updates on the Splunk Community!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...