Postgres Pro
Downloads
Home   >   mailing lists

Re: Regex for (A) and (B) to find in Bus Stop (A) or (B) - Mailing list pgsql-general

From David G. Johnston
Subject Re: Regex for (A) and (B) to find in Bus Stop (A) or (B)
Date
Msg-id CAKFQuwYYCbV2V+WJWWEdLAOSv8=FsmrQeqf1=iDNdxFehEEWTg@mail.gmail.com
Whole thread Raw
In response to Re: Regex for (A) and (B) to find in Bus Stop (A) or (B)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On Wednesday, November 3, 2021, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wednesday, November 3, 2021, Shaozhong SHI <shishaozhong@gmail.com> wrote:
What is the regex for (A) and (B) to find in Bus Stop (A) or (B)?

Not tested…

^Bus\sStop\s\((\w)\)\sor\((\w)\)$ 

The \s can just written as a space though the above seems clearer in email (though it allows for non-space whitespace too)

Sorry, the actual matcher probably should be something like:
[^)]+

So it matches everything except the closing paren.  If the value can contain a paren its more complicated and I’d need to test and check to figure it out.

David J.
 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Regex for (A) and (B) to find in Bus Stop (A) or (B)
Next
From: Bryn Llewellyn
Date:
Subject: Re: to_date() and to_timestamp() with negative years