title: How can I use regular expressions to select text between commas?
body: <p>I am using BigQuery on Google Cloud Platform to extract data from GDELT. This uses an SQL syntax and regular expressions.</p>
  
  <p>I have a column of data (called V2Tone), in which each cell looks like this:</p>
  
  <p><code>1.55763239875389,2.80373831775701,1.24610591900312,4.04984423676012,26.4797507788162,2.49221183800623,299</code></p>
  
  <p>To select only the first number (i.e., the number before the first comma) using regular expressions, we use this:</p>
  
  <p><code>regexp_replace(V2Tone, r',.*', '')</code></p>
  
  <p><strong>How can we select only the second number</strong> (i.e., the number between the first and second commas)<strong>?</strong></p>
  
  <p><strong>How about the third number</strong> (i.e., the number between the second and third commas)<strong>?</strong></p>
  
  <p>I understand that re2 syntax (<a href="https://github.com/google/re2/wiki/Syntax" rel="nofollow noreferrer">https://github.com/google/re2/wiki/Syntax</a>) is used here, but my understanding of how to put that all together is limited.</p>
  
  <p>If anything is unclear, please let me know. Thank you for your help as I learn to use regular expressions.</p>