BigQuery REGEX_MATCH Equivalent

I'm trying to create a query that will select everything\nthat is not matching a given regex

\n\n

In legacy, we had REGEX_MATCH so I was able to do \nWHERE x NOT REGEX_MATCH("[a-z]")

\n\n

In BigQuery Standard SQL you should use REGEXP_CONTAINS(value, regex) instead

\n\n

For example

\n\n
WHERE NOT REGEXP_CONTAINS(x, r'[a-z]')\n

Ryan-Dallas

posted on

Enjoy 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