Postgres Pro
Downloads
Home   >   mailing lists

Thread: Regex for (A) and (B) to find in Bus Stop (A) or (B)

Regex for (A) and (B) to find in Bus Stop (A) or (B)

From
Shaozhong SHI
Date:
What is the regex for (A) and (B) to find in Bus Stop (A) or (B)?

Regards, David

Regex for (A) and (B) to find in Bus Stop (A) or (B)

From
Shaozhong SHI
Date:


What is the regex for (A) and (B) to find in Bus Stop (A) or (B)?

Regards, David

Re: Regex for (A) and (B) to find in Bus Stop (A) or (B)

From
"David G. Johnston"
Date:
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)

David J.

Re: Regex for (A) and (B) to find in Bus Stop (A) or (B)

From
"David G. Johnston"
Date:
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.