Name to Email

[Link86]

Hello,

I have seen many posts on here that allow you to extract a name from an email, but what I am trying to do it take a string that has a first and last name in one column and create a new column with the email address. Example Below

Name	Email
Tom Brady	Tom.Brady@Football.com
Doctor Seuss	Doctor.Seuss@Books.com

Thank you in advance.

[DataNath · Accepted solution]

Hey @Link86, I'm not sure where you're pulling the domain part of the email address from, but I've just set up a quick example as if it comes from another field in the data. The expression here is first replacing the space in the name with a full stop, before adding the @ symbol and then finally the email domain. If your actual scenario is drastically different or you need further help, just shout!