title: Parse Columns in SQL by delimiter
body: <p>In SQL Server, I have a table/view that has multiple columns. The last column looks like this: </p>
  
  <pre><code>COL
  ---------------------------------
  |test|test|test11|testing|final
  |test|test|test1|testing2|final3
  |test|test|test17|testing|final6
  </code></pre>
  
  <p>How do parse this column by <code>|</code> and combine it with the right side of the existing table like such: </p>
  
  <pre><code>COL1     COL2                                COL     Parse1    Parse2    Parse3   Parse4    Parse5
     1        4    |test|test|test11|testing|final       test      test    test11  testing     final
     2        6   |test|test|test1|testing2|final3       test      test    test1  testing2    final3
     5        9   |test|test|test17|testing|final6       test      test    test17  testing    final6
  </code></pre>
  
  <p>There are the same number of parsings for column <code>COL</code>. </p>
  
  <p>Any help would be great thanks!</p>