title: How to make Powershell's Import-Csv correctly import blank spaces
body: <p>I have a CSV file where some of the cells have a blank space in them, and others are just empty. If I run</p>
  <pre><code>&quot; &quot; -eq &quot;&quot;
  </code></pre>
  <p>It returns False so Powershell itself understands the difference between a blank space and an empty string. But, I have a CSV file with the following content:</p>
  <pre><code>Header0,Header1,Header2,Header3
  FillerData, ,,FillerData
  </code></pre>
  <p>When I import this and compare it I get the following:</p>
  <pre><code>PS C:\&gt; $MyCSV = Import-Csv -Path &quot;C:\MyCSV.csv&quot;
  PS C:\&gt; $MyCSV.Header1 -eq &quot; &quot;
  False
  
  PS C:\&gt; $MyCSV.Header1 -eq &quot;&quot;
  True
  
  PS C:\&gt; $MyCSV.Header2 -eq &quot; &quot;
  False
  
  PS C:\&gt; $MyCSV.Header2 -eq &quot;&quot;
  True
  </code></pre>
  <p>So, Import-Csv defaults to treating CSV entries with a blank space as equal to an empty string, when they're not equal. I really need to import the blank spaces for my use case. Is there any way to make Import-Csv correctly import the blank spaces instead of treating them as empty strings?</p>