Regexp extract to match number of 8 digits after a known string in BigQuery

I need to extract 8 digits after a known string:

| MyString                     | Extract: | \n| ---------------------------- | -------- | \n| mypasswordis 12345678        | 12345678 | \n| # mypasswordis 12345678      | 12345678 | \n| foobar mypasswordis 12345678 | 12345678 |\n

Solution:

Use

SELECT REGEXP_EXTRACT(MyString, r"mypasswordis\s*([0-9]{8})"))\n

Or just

SELECT REGEXP_EXTRACT(MyString, r"mypasswordis\s*([0-9]+)"))

mCollins

posted on