Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Miscellaneous > Re: SUBSTR & IN...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 6 Topic 6954 of 7280
Post > Topic >>

Re: SUBSTR & INSTR

by "stephen O'D" <stephen.odonnell@[EMAIL PROTECTED] > Jun 18, 2008 at 03:08 PM

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
 




 6 Posts in Topic:
SUBSTR & INSTR
Mtek <mtek@[EMAIL PROT  2008-06-16 09:48:01 
Re: SUBSTR & INSTR
joel garry <joel-garry  2008-06-16 10:01:07 
Re: SUBSTR & INSTR
Mtek <mtek@[EMAIL PROT  2008-06-16 10:25:13 
Re: SUBSTR & INSTR
sybrandb@[EMAIL PROTECTED  2008-06-16 22:35:51 
Re: SUBSTR & INSTR
"stephen O'D" &  2008-06-18 15:08:20 
Re: SUBSTR & INSTR
yf110@[EMAIL PROTECTED]   2008-06-18 15:29:46 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 0:05:22 CST 2008.