Bigquery RegExp extract only numbers from string

Question

How do I extract only 1111111 from a product_name column like this in Bigquery:

AB~1111111|Omega | Shoes

I tried the following:

REGEXP_EXTRACT(product_name, r"^([0-9]+)|") AS Product_ID

Wiktor Stribiżew · Accepted Answer · 2022-05-17 20:12:32Z

2

You need to use

REGEXP_EXTRACT(product_name, r"^\D*(\d+)") AS Product_ID

Details:

answered May 17, 2022 at 20:12

Wiktor Stribiżew

631k41 gold badges502 silver badges633 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1