How to extract first and last name from email address?

general
1

If anyone knows, please help me.

2

If email contains first name and last name then only you can extract them.
For extracting you can use substring function, which will return the string
from the indexes which you have provided.
If email addresses are in any pattern like there is underscore between firstname and last name
you can use that character to separate them.