Simple Regex in Bigquery
So one day I woke up and I was like:
So I booted up my free account and started typing:
with test as (select 'ABCD1234' as field)
select regexp_extract(field, '[0-9]{1,3}') as extracted from test --retunrs 123union allselect regexp_extract(field, '[0-9]{1,4}') as extracted from test --…