Re: regexp_substr help, please

From: Doug Miller <>
Date: Tue, 29 Apr 2008 16:56:40 GMT
Message-ID: <nrIRj.182$>

In article <4817502b$>, (Malcolm Dew-Jones) wrote:
>Doug Miller ( wrote:
>: I need to be able to pull just the last name out of a string consisting of
>: lastname and firstname, separated by a comma, or space, or comma and space.
>: Complicating matters somewhat is the fact that lastname might be something
>: like "Mc Kay" or "St. Louis" so simply grabbing everything before the first
>: space isn't sufficient.
>: The closest I've come so far is
>: select regexp_substr ('St. Louis, Ted', '.{4}[A-Z]+') from dual;
>: but this returns only
>: St. L
>[A-Z] doesn't match o

Yeah, I just got back from lunch and realized the same thing. Knew it had to be something stupid like that. Thanks. Received on Tue Apr 29 2008 - 11:56:40 CDT

Original text of this message