BigQuery REGEX_MATCH Equivalent
I'm trying to create a query that will select everything that is not matching a given regex
In legacy, we had REGEX_MATCH so I was able to do
WHERE x NOT REGEX_MATCH("[a-z]")
In BigQuery Standard SQL you should use REGEXP_CONTAINS(value, regex)
instead
For example
WHERE NOT REGEXP_CONTAINS(x, r'[a-z]')
Ryan-Dallas
posted on 03 Jun 19Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds
Post Comment