So I have an example string type column in Bigquery that contains data like this:
abc_def
or
|def|ggg|abc
And I am trying to capture the abc by using REGEX_CONTAINS(lower(column_name), r'b\abc\b) but the condition returns false as if it's not functioning properly and reading the abc (we've built it this way so that we capture the exact phrasing needed).
What am I doing wrong?
