Hello

I can extract a domain from an email address but not the first name and last name.

Primarily because some email addresses might not have a dot and therefore a split between first name and last name.

And also because some domains might have several dots e.g. virgin.co.uk

What I need is a calculation where the email address below:

joe.field@virgin.co.uk can be returned as:

first name: joe

last name: field

and something like jfield@virgin.co.uk can be returned as:

last name: field

assuming the first letter is the initial.

I don't think its tricky but could not figure it out.