Convert Name to Email

[Becherer]

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 [email protected]

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?

[Becherer]

@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%.

[nickhills · Accepted solution]

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"