title: Regular Expression to extract a value between curly brackets
body: <p>I have a column with a lot of comma-separated URL parameters in a bigquery table.</p>
  
  <p>Most of the URL parameters contain ifmobile and ifnotmobile values in curly brackets. </p>
  
  <p>I would like to extract these and write them in separate columns. But the values and lengths are not definite, but they are always in curly brackets and start with ifnotmobile or ifmobile.</p>
  
  <p>Here some examples:</p>
  
  <p><strong>URL Parameter</strong></p>
  
  <ol>
  <li><code>{"track":"{ifnotmobile:-215181}{ifmobile:-1039775}"}</code></li>
  <li><code>{"track":"{ifmobile:-1173731}{ifnotmobile:-1173730}"}</code> </li>
  <li><code>{"nccoupon":"%2B5PRDKCLV","track":"{ifmobile:-1029110}{ifnotmobile:159860}"}</code></li>
  </ol>
  
  <p>In these three examples, I would like to have two new columns with all ifmobile and all ifnotmobile values.</p>
  
  <p><strong>Extracted Values</strong></p>
  
  <p><strong>Column ifnotmobile</strong></p>
  
  <ol>
  <li><p>-215181</p></li>
  <li><p>-1173730</p></li>
  <li><p>159860 </p></li>
  </ol>
  
  <p><strong>Column ifmobile</strong></p>
  
  <ol>
  <li><p>-1039775</p></li>
  <li><p>-1173731</p></li>
  <li><p>-1029110</p></li>
  </ol>
  
  <p>I am very happy for any help I can get.
  I tired it already with some REGEXP_EXTRACT, but I failed.</p>
  
  <p>Thanks a lot in advance,
  Phil</p>