title: PowerShell - import CSV with # as the first header
body: <p>I'm having a problem importing this CSV and extracting the specific columns that  I need.
  If I manually remove the first column or change the column heading to anything else and save the CSV, then it works.
  But If I have &quot;#&quot; as the first column heading it messes up. and the output is not correct and only one random column is shown.</p>
  <p><strong>CSV headers</strong></p>
  <p><img src="https://i.stack.imgur.com/VpHLY.png" alt="CSV image" /></p>
  <p><strong>Code:</strong></p>
  <pre><code> $Headers = @(
      &quot;Workstation Type&quot;
      &quot;Model&quot;
      &quot;Asset Tag&quot;  
  )
  Import-Csv 'C:\CSVFiles\DeployedInventory_Workstations.csv' | Select $Headers| Export-Csv -Path 'C:\CSVFiles\DeployedInventory_Workstations2x.csv'-NoTypeInformation
  </code></pre>