title: Snowflake Regular Expression
body: <p>I have this string in Snowflake column:</p>
  <pre><code>\[
  {
  &quot;entryListId&quot;: 3279,
  &quot;id&quot;: 4617,
  &quot;name&quot;: &quot;SpecTra&quot;,
  &quot;type&quot;: 0
  },
  {
  &quot;entryListId&quot;: 3279,
  &quot;id&quot;: 7455,
  &quot;name&quot;: &quot;Signal Capital Partners&quot;,
  &quot;type&quot;: 0
  }
  \]
  </code></pre>
  <p>I need to get names in this format regardless of the number of company names:  &quot;SpecTra, Signal Capital Partners&quot;. In other words, I need to extract company names and concatenate them.</p>
  <p>I have tried this :</p>
  <pre><code>regexp_replace(col, '&quot;(\[^&quot;\]+)&quot;|.', '\\1|') 
  </code></pre>
  <p>and
  <strong>regexp_substr()</strong> function, but did not get the desired output</p>
  <p>Can you please help me with this?
  Thanks</p>