Re: An Oracle 10g Question

From: <>
Date: Fri, 25 Jan 2008 13:44:05 -0800 (PST)
Message-ID: <>

On Jan 25, 3:00 pm, "" <> 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'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 Received on Fri Jan 25 2008 - 15:44:05 CST

Original text of this message