title: Remove certain content from excel file within powershell
body: <p>Currently have a small function that will import a downloaded CSV and export with the required headers. I am looking to filter it down more by removing certain content within one of the columns. col2 contains data I wish to filter down even more.</p>
  
  <pre><code>function Calls {
      write-host "Calls Function Enabled" -ForegroundColor Green 
      $Date = (Get-Date).day,(Get-Date).Month,(get-date).year 
      $Path = "C:\Users\$env:username\desktop\Charges - $Date.csv" 
      Import-Csv -Path "c:\users\$env:username\downloads\Export.csv" | 
          Select-object "col1", "col2","col3","col4"  | 
          export-csv -Path ${path} 
      start-process explorer "C:\Users\$env:username\desktop\Charges - $Date.csv"
  }
  </code></pre>