HOW TO PICK USER NAME FROM EMAIL ADDRESS OR PROFILE

[Achiever2023]

Am working on an automation email bot.

I have a form that retrieve user's email address (using usermail() function).

In the body of my automation email, I want the content to be below 

user mail is:<(PII Removed by Staff)>

the column name for the email is created_by

Dear created_by,

Your request have been received.

Thank you.

OUTPUT:

Dear <(PII Removed by Staff)

Your request have been received.

Thank you.

BELOW IS THE RESULT I WANTED

Dear Henry,

Your request have been received.

Thank you

How do I go about it please?

[AleksiAlkio · Accepted solution]

INDEX(SPLIT([Email],"@"),1) gives you "henry.ford"
SUBSTITUTE(INDEX(SPLIT([Email],"@"),1),"."," ") gives "henry ford"
INDEX(SPLIT([Email],"."),1) gives "henry"
UPPER(LEFT([Email],1))&MID(INDEX(SPLIT([Email],"."),1),2,20) gives Henry.
But you need to add IF statement if the email contains "." before "@" or not.

[Achiever2023]

Thank you AleksiAlkio,

Please what if the user's email doesn't contain his first name or last name, rather uses nicknames or alphanumeric names(e.g <PII removed by staff>)  how do I get their first name or last name eventually please?

[AleksiAlkio]

If you don't have all email addresses in a separate table and their names, you can't