title: Translating a column containing comma separated codes
body: <p>There is some data I'm trying to report on, one of the columns required contains a list of comma separated 2-character codes that I then need to &quot;translate&quot; back to the description it represents e.g. let's say it's about people and their personality traits. The data is stored like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>person_id</th>
  <th>traits</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>OU,AD</td>
  </tr>
  <tr>
  <td>2</td>
  <td>AB,CD,EF,GH,IJ</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>And say these &quot;codes&quot; represent descriptions like:</p>
  <p><code>OU = Outgoing</code>
  <code>AD = Adventurous</code></p>
  <p>etc. So for person_id = 1 I'd want the output for Traits to be:</p>
  <p><code>Outgoing, Adventurous</code></p>
  <p>There is a set list of codes that could be listed, there is no lookup table to match the codes to their descriptions, and each record can have a different number of codes within the <code>traits</code> column.</p>
  <p>What would be the best way to &quot;translate&quot; this column as above?</p>