title: How can I split this string as a UDF
body: <p>I have this column (from an export from BigCommerce Database) that holds custom fields in a single column. Here's one example of the data:</p>
  
  <pre><code>[{"Name":"Unit Number","Value":"3698"},{"Name":"Region","Value":"Eastern Great Lakes (WNY, W PA)"}]
  </code></pre>
  
  <p>I need a way to figure out how to extract the Field/Value pairs from this. In this sample, I'd like to get, as output:</p>
  
  <pre><code>Unit Number:3698
  Region:Eastern Great Lakes (WNY, W PA)
  </code></pre>
  
  <p>I'm hoping to have as a result a UDF that I can run as a part of a select query that gives me just the field name and the value output as a string (as exampled above). Every column of data in the source table has this format. Typically, the column data has two field/value pairs, but sometimes none, sometimes two, sometimes three. In other words, the column holds any number of variable field/value pairs.</p>
  
  <p>Does anyone have any suggestions on how to build a UDF to help get those data elements out of this string?</p>
  
  <p>I was tinkering around with things, but I'm stuck. I started with trying to remove the extraneous characters <code>[,]</code> which mean nothing, and <code>{,}</code> which delineate the field and the value. I was tinkering with string-split functions, but instead of splitting on a single character, I can't figure out how to split based upon pairs of open or closing brackets <code>{,}</code> to narrow it down. </p>
  
  <pre><code>Unit Number:3698 | Region:Eastern Great Lakes (WNY, W PA)
  </code></pre>