SUBSTR & INSTR
From: Mtek <mtek_at_mtekusa.com>
Date: Mon, 16 Jun 2008 09:48:01 -0700 (PDT)
Message-ID: <77f38352-d1d1-4496-88ce-d872df2a1e65@i76g2000hsf.googlegroups.com>
Date: Mon, 16 Jun 2008 09:48:01 -0700 (PDT)
Message-ID: <77f38352-d1d1-4496-88ce-d872df2a1e65@i76g2000hsf.googlegroups.com>
Hi,
I'm looking to parse an email. Say I have an email like this:
johnjones_at_gmail.abc.def.ghi.com
I basically want johnjones_at_gmail.abc.def.ghi in one variable and the .com in the other.
If the email is this:
jjones_at_amail.co
The same, I basically want jjones_at_amail.co 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 Received on Mon Jun 16 2008 - 11:48:01 CDT