Re: how do i split a string

From: Bob Jones <email_at_me.not>
Date: Mon, 13 Oct 2008 20:43:24 -0500
Message-ID: <ZOSIk.596$%11.297@flpi144.ffdc.sbc.com>

<emdproduction_at_hotmail.com> wrote in message news:8a7a71fc-e783-4e0a-8a00-ae8d984c8024_at_d31g2000hsg.googlegroups.com...
> group,
>
> I have a record like this
> 12**5***
>
> I need to know the 1st occurance of *, and length of it
> the 2nd occurance of * and the length of it
>
> for example, for 12**5***, I need to get 3263
> meaning the 1st one start at 3, length is 2, the 2nd one start at 6,
> the length is 2
>
> Your help is highly appreciated

select regexp_instr('12**5***','\*+',1,1)

||length(regexp_substr('12**5***','\*+',1,1))
||regexp_instr('12**5***','\*+',1,2)
||length(regexp_substr('12**5***','\*+',1,2))
from dual Received on Mon Oct 13 2008 - 20:43:24 CDT

Original text of this message