How to remove only letters from a string in BigQuery?

For example:

XXXX123456
AAAA123456789
XYZR12345678
ABCD1234567
1111
2222

I want the end result to look like:

Solution:

You can use regexp_replace():

select regexp_replace(str, '[^0-9]', '')

posted on 30 Dec 18

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds