Extract numbers from parentheses using regexp

Home > OS > Extract numbers from parentheses using regexp_extract?

Extract numbers from parentheses using regexp_extract?

Time：09-21

I have the following value: S/O BOISE CASCADE (60031167) how do I extract the value in the parentheses so that I have a new column in my table that is 60031167?

CodePudding user response：

You can use this regular expression:

select regexp_extract('S/O BOISE CASCADE (60031167)', '[(]([^)] )[)]')

Page link：https//www.codepudding.com/os/119928.html

Prev:RegEx, characters between 2 strings without positive lookbehind

Next:Regex to convert URL to string

Tags：

regex

Links：
CodePudding