MIME-Version: 1.0
References: <18A99BB3-EB26-47A3-94D6-D951E984D982@aweber.com>
In-Reply-To: <18A99BB3-EB26-47A3-94D6-D951E984D982@aweber.com>
From: jian he <jian.universality@gmail.com>
Date: Fri, 13 Sep 2024 09:14:51 +0800
Message-ID: 
 <CACJufxELF8JF=HazRv1r-zYTvLog6vDjwo8wsgpT6K0xdQ_jWw@mail.gmail.com>
Subject: Re: Regexp_replace help
To: Chris Hoover <chrish@aweber.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CACJufxELF8JF%3DHazRv1r-zYTvLog6vDjwo8wsgpT6K0xdQ_jWw%40mail.gmail.com>
Precedence: bulk

On Fri, Sep 13, 2024 at 5:18=E2=80=AFAM Chris Hoover <chrish@aweber.com> wr=
ote:
>
> Looking for some help here.  I have a string that has =E2=80=98code1234=
=E2=80=99 in it.  The 1234 can vary and I won=E2=80=99t know what they woul=
d be.  Trying to figure out how to use regexp_replace to trim down the stri=
ng, but unsure how to keep the =E2=80=98code1234=E2=80=99 in the string.
>
>
> The search should be =E2=80=98 code[0-9]+? .*=E2=80=99. However, I don=E2=
=80=99t understand what the replace should be.
>
> I.E.:
> SELECT regexp_replace(=E2=80=99This is my test string that caused code12 =
from abc=E2=80=99,
>                                          =E2=80=98 code[0-9]+? .*=E2=80=
=99,
>                                          =E2=80=98What should this be so =
I keep the code12?=E2=80=98)
> Desire result:
> =E2=80=99This is my test string that caused code12=E2=80=99
>
>
> SELECT regexp_replace(=E2=80=99This is my second test string and it is ca=
using code1234 from def.  The weather is nice. :)=E2=80=99,
>                                          =E2=80=98 code[0-9]+? .*=E2=80=
=99,
>                                          =E2=80=98What should this be so =
I keep the code1234?=E2=80=99)
> Desire result:
> =E2=80=98This is my second test string and it is causing code1234=E2=80=
=99
>

please try these.

select SUBSTRING($$This is my test string that caused code12 from
abc$$ from '.*(?:code[0-9]\S+)');
select SUBSTRING($$This is my test string that caused code12s1 from
abc$$ from '.*(?:code\S+)');
SELECT SUBSTRING($$This is my second test string and it is causing
code1234 from def.  The weather is nice. :$$
from '.*(?:code\S+)');