title: Extract any and all characters between " " using Big Query REGEX
body: <p>I need to extract just '"Loc":"CART",' from this larger string:</p>
  
  <pre><code>hits_eventInfo_eventLabel = {"AV":6,"CV":1,"PV":1,"AS":"1,2,3,4","Loc":"CART","PN":"Supreme Lover's® - 12\" Medium","PS":"6716a12c-0067-4d72-b560-a0dbd1197185"}
  </code></pre>
  
  <p>"Loc" will always stay the same, the value where "CART" exists could change. </p>
  
  <p>I am trying the following sql:</p>
  
  <pre><code>REGEXP_EXTRACT(hits_eventInfo_eventLabel, '"Loc":".*",') as Recommendation_Location
  </code></pre>
  
  <p>but it is returning the entire rest of the string starting after "Loc". </p>
  
  <p>I am using standard sql in Google BigQuery, and have been looking at all the documentation but can't seem to figure out how to grab just the characters inside of the quotes.</p>
  
  <p>Any help would be appreciated, thanks!</p>