title: Teradata Sub-string Before and After certain character
body: <p>I am looking for a way to extract text that is before and after a certain character in Teradata. For example, I have a column that is consistent except for the word in the middle - which I want to extract.</p>
  
  <p>I have these two examples:</p>
  
  <ol>
  <li>"Customer Activated Account DD: ABCD, ON DATE XXXX" </li>
  <li>"Customer Activated Account DD: EFGH, ON DATE XXXX"</li>
  </ol>
  
  <p>I need the text that exists right after ":" and before "," - in this case ABCD or EFGH. So far I have <code>SUBSTRING (column FROM POSITION ('DD: ' IN column) +4)</code> but that returns everything after the ":" like <code>ABCD, ON DATE XXXX</code>.</p>