Re: REGEXP_MATCH with space does not match

2022-04-26 Thread francis....@gmail.com
Hi Nirmita, thank you for pointing me out to the Grammar Guide, but I already red it thorougly and could not find a precise reference on how to escape caracters in regular expressions. It says the regular expression uses the re2 syntax , but I found ou

REGEXP_MATCH with space does not match

2022-04-25 Thread francis....@gmail.com
Hi there, I have a very simple query where I need to match a campaign name with a regular expression: SELECT ad_group_ad.ad.call_ad.description1, campaign.name, metrics.active_view_impressions, metrics.all_conversions FROM ad_group_ad WHERE metrics.impressions > 0 AND campaign.name REGEXP_MAT