title: Splitting text to column by qualifiers with SQL Server
body: <p>I'm looking to split records from 1 column to many columns. The data is comma delimited with columns that are text wrapped with double quotes. While there is no comma in text that is wrapped by quotes, SSIS and the import wizard will parse the data fine.
  The problem is when double quote wrapped text contains a comma - this comma fools SSIS and the wizard into splitting that column into 2 column.</p>
  
  <p>For example:  </p>
  
  <blockquote>
    <p>"abc", "def", 123, "ghi, jkl", 456</p>
  </blockquote>
  
  <p>Should come out:  </p>
  
  <pre><code>col1  col2  col3  col4     col5  
  abc   def   123   ghi,jkl  456
  </code></pre>
  
  <p>I've found ways on splitting by delimiter but how can I include a "skip" when the comma is between double quote?</p>
  
  <p>Thanks.</p>