topic Convert Name to Email in Reporting

Convert Name to Email

Becherer — Mon, 14 Dec 2020 20:17:19 GMT

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?

nickhills — Mon, 14 Dec 2020 21:28:45 GMT

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"

Becherer — Wed, 16 Dec 2020 07:31:02 GMT

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