title: Remove part contents in csv file using python
body: <p>I have a CSV file that has a description column. In that description the string ends in 'CAD' then some numbers.</p>
  <p>Here is what the description looks like.</p>
  <pre><code>|Description|
  |Case Number and Notes: CAD ID: 21-012886|
  |Case Number and Notes: 21-12882 , check a safety hazardCAD ID: 21-012882|
  |Case Number and Notes: 21-12877 , Follow up|
  </code></pre>
  <p>What I want to do is delete the characters in those cells that is before 'CAD'.</p>
  <p>Is this possible, and if so, how is it possible?</p>