On Aug 22, 3:31 pm, DA Morgan <damor..._at_psoug.org> wrote:
> jobs wrote:
> > I'm on Oracle 9i. Is there any built in function that would return the
> > first token or string from a string?
>
> > For example, given string = " bob lfcr bill"
>
> > I want to return "bob"
>
> > imediately following bob there might be cases where we have a linefeed/
> > cr.
>
> > Thanks for any help or information.
>
> Look at REGEXP_SUBSTRhttp://www.psoug.org/reference/regexp.html#rerp
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Is that supported in 9i? I can't seem to get it to work here.
Received on Wed Aug 22 2007 - 14:38:22 CDT
