title: How to parse data from a CLOB in SQL Server?
body: <p>I would like to use OPENROWSET with the BULK command to load data into SQL Server as a CLOB, and as a second step to parse the CLOB and load read the data as a table.</p>
  
  <p>E.g.: </p>
  
  <pre><code>SELECT BulkColumn 
  FROM OPENROWSET (BULK 'c:\somedir\somefile.txt', SINGLE_CLOB) TheFile
  </code></pre>
  
  <p>yields:</p>
  
  <pre><code>BulkColumn
  Col1,Col2,Col3,1,2,3,1,2,3,1,2,3,1,2,3
  </code></pre>
  
  <p>I want to select this as:</p>
  
  <pre><code>Col1   Col2   Col3
  1      2      3
  1      2      3
  1      2      3
  </code></pre>