title: Powershell csv creating a new column with 2 others
body: <p>Here is my script so far. I want to create a new column called <code>password</code> but only use the first letter of column <code>Associate_First_Name</code>, the  first letter of <code>Associate_Last_Name</code> and the last 4 of <code>Associate_SIN_SSN</code>. How do I only pull certain values from a column?</p>
  
  <pre><code>$CSV = import-csv "C:\csv" | select Associate_First_Name,Associate_Last_Name,Associate_Email,Associate_SIN_SSN,@{n=’password’;e={$_.Associate_First_Name+ $_.Associate_Last_Name+ $_.Associate_SIN_SSN}}
  
  $CSV | export-CSV "C:\csv"-NoTypeInformation 
  </code></pre>