Re: An Oracle 10g Question

On Jan 25, 3:44 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Jan 25, 3:00 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
>
>
>
> > Hi All,
>
> > First, thanks to those who helped me eariler in the week with that
> > complex regular expression. I have another one.
>
> > Here is my string: "null","null","null","GMO, DXD, SDS, QID,
> > MZZ","90", "3 ASC"
>
> > It can obviously vary, but what I am looking for is the occurrence of
> > this part: "GMO, DXDT, SDS, QID, MZZ"
>
> > Basically I need to know if a string like that exists within the
> > entire string. Notice that there are multiple values within the
> > double quotes.
>
> > The problem is that the last parameter is the same, but I do not want
> > to process that parameter.....it's hard to tell the difference, which
> > is what makes this a nutty thing.....
>
> > I'm hoping to use some type of 10g regular expression within my PLSQL
> > to find it, and then to process it one way or the other if it exists
> > of not......
>
> > Thanks All!!!
>
> Try using REGEXP_INSTR, as it will return the starting position of the
> substring should it exist anywhere in the string. The documentation
> has examples of its use.
>
> David Fitzjarrell

Thanks David. It looks like the pattern I'd be looking for is a double quote (") followed by one or more characters separated by a comma and space (, ) until the next double quote (").

"null","null","null","GMO, DXDT, SDS, QID, MZZ","90", "3 ASC"

So, if I can find that in the string, and pull it out, it will be what I need.

Thanks! Received on Fri Jan 25 2008 - 15:49:22 CST