title: Google BigQuery - Parsing string data from a Bigquery table column
body: <p>I have a table A within a dataset in Bigquery. This table has multiple columns and one of the columns called hits_eventInfo_eventLabel has values like below:</p>
  
  <blockquote>
    <p>{ID:AEEMEO,Score:8.990000;ID:SEAMCV,Score:8.990000;ID:HBLION;Property
    ID:DNSEAWH,Score:0.391670;ID:CP1853;ID:HI2367;ID:H25600;}</p>
  </blockquote>
  
  <p>If you write this string out in a tabular form, it contains the following data:</p>
  
  <pre><code>**ID      |   Score**
  AEEMEO  |   8.990000
  SEAMCV  |   8.990000
  HBLION  |    -
  DNSEAWH |   0.391670
  CP1853  |    -
  HI2367  |    -
  H25600  |    -
  </code></pre>
  
  <p>Some IDs have scores, some don't. I have multiple records with similar strings populated under the column hits_eventInfo_eventLabel within the table.</p>
  
  <p>My question is how can I parse this string successfully <strong>WITHIN BIGQUERY</strong> so that I can get a list of property ids and their respective recommendation scores (if existing)? I would like to have the order in which the IDs appear in the string to be preserved after parsing this data.</p>
  
  <p>Would really appreciate any info on this. Thanks in advance!</p>