title: Separate string by just comma
body: <p>So I created a column that concatenate all the strings like this</p>
  <pre><code>|              col1                 |
  |-----------------------------------|
  |   key,board, warrior,123,ADD      |
  |-----------------------------------|
  | First,First, Last, Name,112,Delete|
  </code></pre>
  <p>and I'm trying to figure out to a way to split them with just comma, not space and comma.</p>
  <pre><code>SELECT
      SPLIT_PART(COL1, ',' 1) AS COL1,
      SPLIT_PART(COL1, ',' 2) AS COL2,
      SPLIT_PART(COL1, ',' 3) AS COL3,
      SPLIT_PART(COL1, ',' 4) AS COL4
  FROM TABLE1
  </code></pre>
  <p>This separates everything with comma like this</p>
  <pre><code>| col1 | col2  | col3  | col4 |
  |-----------------------------|
  | key  | board |warrior| 123  |
  | First| First |  Last | Name |
  </code></pre>
  <p>And I want to split them like this below.</p>
  <pre><code>| col1 | col2              | col3| col4  |
  |----------------------------------------|
  | key  | board, warrior    | 123 | ADD   |
  | First| First, Last, Name | 112 | Delete|
  </code></pre>
  <p>I couldn't find a good reference for this. Please help!</p>