Re: SUBSTR & INSTR

On Jun 16, 5:48 pm, Mtek <m...@[EMAIL PROTECTED]
> wrote:
> Hi,
>
> I'm looking to parse an email.  Say I have an email like this:
>
> johnjo...@[EMAIL PROTECTED]
>
> I basically want johnjo...@[EMAIL PROTECTED]
 in one variable and
> the .com in the other.
>
> If the email is this:
>
> jjo...@[EMAIL PROTECTED]
>
> The same, I basically want jjo...@[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

Depending on whether you are on Oracle 10G or not, regexp_instr and
regexp_substr may be a great help here -
http://www.oracle.com/technology/oramag/webcolumns/2003/techarticles/rischert_regexp_pt1.html