On 12/03/2005 05:48:59 AM, Terry Lee Tucker wrote:
> RE Gurus:
>
> I have a situation where I need to extract a couple pieces of
> information from
> a string. The string, if entered perfectly by the user, would look
> someting
> like this: DUN: 006235835 SID: KT-3616*
>
> I need to extract the 006235835 into one variable and the KT-3616 into
>
> another. Both "numbers" can possibly be something other than numbers
> alone as
> in the SID: part of the string above. I have come up with a way of
> extracting
> both pieces of information where, at least in my mind, the key
> parameters are
> the colon (:) and a space, as in the first case, or asterik (*), as in
> the
> second case, marking the end of the string to extract.
I would tend to use split_part() and avoid regular expressions
altogether.
select split_part('DUN: 006235835 SID: KT-3616*', ' ', 2);
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
