SUBSTR & INSTR

Hi,

I'm looking to parse an email.  Say I have an email like this:

johnjones@[EMAIL PROTECTED]
 basically want johnjones@[EMAIL PROTECTED]
 in one variable and
the .com in the other.

If the email is this:

jjones@[EMAIL PROTECTED]
 same, I basically want jjones@[EMAIL PROTECTED]
 in one variable and
the .com in the other.

I know I have to use SUBSTR & INSTR, but the problem is that I do not
know how many periods may be in the email address.....

Any takers for some help??

Thanks!

John