title: SQL Split function that handles string with delimeter appearing between text qualifiers?
body: <p>There are several SQL split functions, from loop driven, to using xml commands, and even using a numbers table.  I haven't found one that supports text qualifiers.</p>
  
  <p>Using the example string below, I would like to split on ",", but not when it appears between double or single quotes.</p>
  
  <p>Example data:</p>
  
  <pre><code>jsmith@anywhere.com, "Sally \"Heat\" Jones" &lt;sally@anywhere.com&gt;, "Mark Jones" &lt;mjones@anywhere.com&gt;, "Stone, Ron" &lt;rstone@anywhere.com&gt;
  </code></pre>
  
  <p>Should return a table:</p>
  
  <pre><code>jsmith@anywhere.com
  "Sally \"Heat\" Jones" &lt;sally@anywhere.com&gt;
  "Mark Jones" &lt;mjones@anywhere.com&gt;
  "Stone, Ron" &lt;rstone@anywhere.com&gt;
  </code></pre>
  
  <p>I know this is a complex query/function, but any suggestions or any guidance would be mucho appreciated.</p>