Remove/Replace characters after the string

[bhaveshp90]

Hello, 

I have a string like "Tim.Kimball@amazon.com". How to remove the string (email id) to show only First Name and Last Name.

"Tim.Kimball@amazon.com" into "Tim Kimball" (removing the string from @ and replacing the period with a space character)

thanks

[marcus_malinow · Accepted solution]

replace(subfield('Tim.Kimball@amazon.com', '@', 1), '.', ' ')

[sergio0592 · Accepted solution]

try

=subfield('Tim.Kimball@amazon.com','@',1)

[Bionic]

Hi, What if I need to keep rest text after the email e.g.

Orpigina Text : My Email is Tim.Kimball@amazon.com. Please Contact.

Desire Replace Text: My Email is Tim.Kimball****. Please Contact.