title: Change a value in column of a CSV file
body: <p>I'm trying to find a way to change the value of all the entries in the 'Available Person' column in my csv file using PowerShell.</p>
  
  <p>If the value is 'Y' it should be changed to '1' and if the value is 'N' it should be changed to ')':</p>
  
  <pre>Branch Number,      CoreID,     Available Person,      Workstation
  8002,           FMD354800200,   Y,
  8002,           FMD354800201,   Y,
  8002,           FMD354800202,   N,
  8002,           FMD354800203,   N,
  8002,           FMD354800204,   Y,
  </pre>
  
  <p>Here's what I've tried:</p>
  
  <pre><code>$csv=Import-Csv user.csv' | $csv | %{ if($_.'Available Person' -eq "Y") {$_.'Available Person'="1"} } $csv|export-csv user1.csv' -NoTypeInformation
  </code></pre>