title: Using Regex to extract decimal numbers from arrays on Snowflake
body: <p>The column ('DATA') I want to extract the decimal from is in the following format:</p>
  <p>{
  &quot;unit&quot;: &quot;Miles&quot;,
  &quot;value&quot;: 59290.6
  }</p>
  <p>I've tried the following code by I get a null...</p>
  <pre><code>regexp_substr(DATA, '\{\d+.\d+\}') AS RECORDED_DISTANCE
  </code></pre>