title: Split a string after a specific character in BigQuery
body: <p>I have a field that contains street name, state, and zip code that I need to pull just the state abbreviation from. I tried using SUBSTR but the challenge is that sometimes the zip codes are the full 9 digit zipcodes (and not just the 5 digit zips). I'm sure there is an easy way to do this with maybe REGEX but I can't figure out the correct syntax.</p>
  <p><strong>Example</strong>:
  123 Street ABC, NY 12345
  1234 Street, NY 12345-1234</p>
  <p><strong>Need to return</strong>:  NY</p>