title: Find and replace inside one csv column with powershell
body: <p>I have a large CSV file that looks like this named student.export.text</p>
  
  <p>Student Number,Last Name,Middle Name,First Name,Schoolid,Grade Level,Dob</p>
  
  <p>I'm trying to build an automated task that will run nightly so that another piece of software can understand the CSV correctly.</p>
  
  <p>Here is my code, but I'm missing something that is causing an error.  I am new to Powershell and I am hoping for some advice.</p>
  
  <p>Any help will be greatly appreciated!</p>
  
  <pre><code>$Replacements = @{
    "5" = "AE";
    "7" = "ER";
    "10" = "FM";
    "12" = "HC";
    "14" = "JH";
    "18" = "LE";
  
      #...]
  }
  
  
  Import-Csv .\student.export.text | ForEach-Object {
      $_.Schoolid = $Replacements[$_.Schoolid]
      $_
  } | Export-Csv -NoTypeInformation .\new.csv
  </code></pre>