title: How to parse string from column in csv in Powershell
body: <p>I have a csv configured as such:</p>
  
  <pre><code>PK,INV_AMT,DATE,INV_NAME,NOTE
  1,123.44,634,asdfljk,TEST 12OING 06/01/2010 DATE: 04/10/2012
  2,123.44,634,wet aaa,HI HOW ARE YOU 11.11 DATE: 01/01/2011
  3,123.44,634,dfssdsdfRR,LOOK AT ME NOW….HI7&amp;&amp;&amp; DATE: 06/11/1997
  4,123.44,634,asdfsdgg,LOOK AT ME NOW….HI7&amp;&amp;&amp; DATE: 03-21-2097
  5,123.44,634,45746345,LOOK AT ME NOW….HI7&amp;&amp;&amp; DATE: 02/18/2000
  </code></pre>
  
  <p>How can I parse the date after the string "<code>DATE</code>:" in the note column using powershell?</p>
  
  <p>For example, the first row has the string "<code>TEST 12OING 06/01/2010 DATE: 04/10/2012</code>" in the note column. I need to parse '<code>04/10/2012</code>' out of that row.</p>
  
  <p>I would like to be able to read from a csv file such as the one above and parse out that date and add it as a new column in the csv file.</p>
  
  <p>Thanks for any help.</p>