title: How to get count of matches of a regexp in a string in bigquery?
body: <p>How would one go about getting the count of matches of a reqular expression in a string in bigquery?  I don't think bigquery sql supports regexp_count.</p>
  
  <p>So, for example, you might want to count the matches of "foo* " in a string like "foo1 foo foo40" and it would return a count of 2 (in this case, I am meaning that the "*" must be a non-empty string).</p>
  
  <p>Thanks!</p>