Re: An Oracle 10g Question

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 Received on Fri Jan 25 2008 - 15:44:05 CST