title: BigQuery; extract numbers only from a string
body: <p>my data looks like a 1x1000 vector with variable number of inputs in a like. sometimes it is just age but sometimes they add weight and state ID.</p>
  
  <pre><code>85 age
  15 age; 68 Weight
  25 age; 80 Weight; 02 Alaska
  72 Weight; 50 Wyoming
  </code></pre>
  
  <p>What I would like to get as output are just numbers - i.e.</p>
  
  <pre><code>85
  15 68 
  25 80 02 
  72 50
  </code></pre>
  
  <p>I don't succeed that much using SPLIT since that gives me over 2000 lines back instead of 1000. So I don't know how to do it.
  Unless SPLIT could be combined and tell me how many information points were there before split. I.e. </p>
  
  <pre><code>85    1
  15    2
  68    2
  25    3
  80    3
  </code></pre>
  
  <p>etc.</p>