title: Removing single and double quotes from BigQuery using regexp_extract
body: <p>I'm a total noob with regexp. All I want to do is to remove the single and double quotes from a string in BigQuery. I can remove the single and double quotes at the beginning of the string, but not the end:</p>
  
  <p><code>SELECT regexp_extract(foo, r'\"new_foo\":\"(.*?)\"') AS new_foo 
  FROM [mybq:Schema.table]</code></p>
  
  <p>All I get is Null but without <code>regexp_extract</code> I have expected results. Help is appreciated.</p>