title: Remove all characters in a row with re.sub python
body: <p>I am trying to edit the data to replace ALL characters before a set point. Currently I have got this far with Python but this gives me a error "TypeError: 'str' object is not callable"</p>
  
  <p>Here is the data set before and what I am trying to achieve:</p>
  
  <pre><code>Header 1,Header 2,Header 3,Header 4,Header 5 
  1,2,3,4,DESCRIPTION
  1,2,3,4,DEffffSCRIPTION
  1,2,3,4,aaaaDESCRIPTION
  1,2,3,4,&lt;&gt;DESCRIPTION
  </code></pre>
  
  <p>Here is what I am trying to achieve:</p>
  
  <pre><code>Header 1,Header 2,Header 3,Header 4,Header 5 
  1,2,3,4,SCRIPTION
  1,2,3,4,SCRIPTION
  1,2,3,4,SCRIPTION
  1,2,3,4,SCRIPTION
  </code></pre>
  
  <p>If you can help fix the TypeError in the re.sub or if you can help overall that would be great thank you.</p>
  
  <p>Here is my python code.</p>
  
  <pre><code>import csv
  import re
  
  with open('2.csv', "r") as inFile:
      reader = csv.reader(inFile)
      for row in reader:
          row[4](re.sub(r'.*SC', r'SC.*', row[4]))
  </code></pre>