title: SUBSTRING_INDEX in BigQuery
body: <p>I wanted to extract a person's first name from a column containing sms texts. The texts generally begin with the word "Dear". eg. Dear Micheal Bay, your movie tickets...</p>
  
  <p>While on mysql, I used   <code>SUBSTRING_INDEX(SUBSTRING_INDEX(sms_text, " ", 2)," ", -1)</code>, but now i have to do the same thing on BIgQuery and I am unable to find a similar function. </p>
  
  <p><strong>Sample Data:</strong> </p>
  
  <p><strong>Sms_text</strong></p>
  
  <p>Dear, Micheal Jordan, your match tickets have been mailed to you.</p>
  
  <p>Dear Virat Kohli, your flight will depart in 25 mins.</p>
  
  <p><strong>Desired Output:</strong></p>
  
  <p>Micheal</p>
  
  <p>Virat</p>
  
  <p>Can someone help me out with this?</p>