Re: Regular Expression Question
От | Karl O. Pinc |
---|---|
Тема | Re: Regular Expression Question |
Дата | |
Msg-id | 1133630578l.28211l.1l@mofo обсуждение исходный текст |
Ответ на | Regular Expression Question (Terry Lee Tucker <terry@esc1.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: