title: Parsing within a field using SQL
body: <p>We are receiving data in one column where further parsing is needed. In this example the separator is ~.
  Goal is to grab the pass or fail value from its respective pair.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>SL</th>
  <th>Data</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>&quot;PARAM-0040,PASS~PARAM-0045,PASS~PARAM-0070,PASS&quot;</td>
  </tr>
  <tr>
  <td>2</td>
  <td>&quot;PARAM-0040,FAIL~PARAM-0045,FAIL~PARAM-0070,PASS&quot;</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Required outcome:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>SL</th>
  <th>PARAM-0040</th>
  <th>PARAM-0045</th>
  <th>PARAM-0070</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>PASS</td>
  <td>PASS</td>
  <td>PASS</td>
  </tr>
  <tr>
  <td>2</td>
  <td>FAIL</td>
  <td>FAIL</td>
  <td>PASS</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>This will be a part of a bigger SQL query where we are selecting many other columns, and these three columns are to be picked up from the source as well and passed in the query as selected columns.</p>
  <p>E.g.</p>
  <pre><code>Select Column1, Column2, [ Parse code ] as PARAM-0040, [ Parse code ] as PARAM-0045, [ Parse code ] as PARAM-0070, Column6 ..... 
  </code></pre>
  <p>Thanks</p>