Hi,

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

johnjones (AT) gmail (DOT) abc.def.ghi.com

I basically want johnjones (AT) gmail (DOT) abc.def.ghi in one variable and
the .com in the other.

If the email is this:

jjones (AT) amail (DOT) co

The same, I basically want jjones (AT) amail (DOT) 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

On Jun 16, 9:48*am, Mtek <m... (AT) mtekusa (DOT) com> wrote:
Can you not just check whatever is after the last period and decide
then? There are only so many domains in the world. See the docs on
instr about how to search backwards from the end of the string.

But I must say, one of my domains ends with .to and does not have
a .com, so I guess I'm thankful you can't spam me! :-)

jg
--
@home.com is bogus.
Sorry, not drunk enough: http://www.signonsandiego.com/uniont...b14lerach.html

On Jun 16, 9:48*am, Mtek <m... (AT) mtekusa (DOT) com> wrote:
Can you not just check whatever is after the last period and decide
then? There are only so many domains in the world. See the docs on
instr about how to search backwards from the end of the string.

But I must say, one of my domains ends with .to and does not have
a .com, so I guess I'm thankful you can't spam me! :-)

jg
--
@home.com is bogus.
Sorry, not drunk enough: http://www.signonsandiego.com/uniont...b14lerach.html

On Jun 16, 9:48*am, Mtek <m... (AT) mtekusa (DOT) com> wrote:
Can you not just check whatever is after the last period and decide
then? There are only so many domains in the world. See the docs on
instr about how to search backwards from the end of the string.

But I must say, one of my domains ends with .to and does not have
a .com, so I guess I'm thankful you can't spam me! :-)

jg
--
@home.com is bogus.
Sorry, not drunk enough: http://www.signonsandiego.com/uniont...b14lerach.html

On Jun 16, 9:48*am, Mtek <m... (AT) mtekusa (DOT) com> wrote:
Can you not just check whatever is after the last period and decide
then? There are only so many domains in the world. See the docs on
instr about how to search backwards from the end of the string.

But I must say, one of my domains ends with .to and does not have
a .com, so I guess I'm thankful you can't spam me! :-)

jg
--
@home.com is bogus.
Sorry, not drunk enough: http://www.signonsandiego.com/uniont...b14lerach.html

On Jun 16, 12:01 pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Thanks a bunch. Was unaware that Oracle offered a reverse INSTR
lookup.....

On Jun 16, 12:01 pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Thanks a bunch. Was unaware that Oracle offered a reverse INSTR
lookup.....

On Jun 16, 12:01 pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Thanks a bunch. Was unaware that Oracle offered a reverse INSTR
lookup.....

On Jun 16, 12:01 pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Thanks a bunch. Was unaware that Oracle offered a reverse INSTR
lookup.....

On Mon, 16 Jun 2008 10:25:13 -0700 (PDT), Mtek <mtek (AT) mtekusa (DOT) com>
wrote:

Not surprisingly. Most questions here and on OTN are redundant, while
doc questions.
Most people don't read docs before posting, and continue not to read
them after being pointed to the docs.

--
Sybrand Bakker
Senior Oracle DBA