title: Delete spaces and column in csv with powershell
body: <p>I'm trying to convert a downloaded ".txt" file into a goodlooking and useful ".csv" file using powershell. I'm kindly advanced with this task but shortly before the goal I have some problems which I can not manage.</p>
  
  <p>It is a list with the OUI-Part of mac-addresses and its names.
  This is how it looks like (without quotation):</p>
  
  <pre><code>" 00-00-00   "  EMPTY COLUMN    "XEROX CORPORATION"
  " 00-00-01   "  EMPTY COLUMN    "XEROX CORPORATION"
  </code></pre>
  
  <p>My first question now is, how can I get the spaces in the column of the OUI-address away. The secound one, how can I delete the empty column.</p>
  
  <p>In the end it should look like this (without quotation):</p>
  
  <pre><code>"00-00-00" "XEROX CORPORATION"
  "00-00-01" "XEROX CORPORATION"
  </code></pre>
  
  <p>So that we have in the first column the OUI without any spaces and in the second column the name of the company. But here it is important to have spaces in the name.</p>
  
  <p>Original file content:  </p>
  
  <pre><code>  00-00-09          XEROX CORPORATION
    00-00-0A          OMRON TATEISI ELECTRONICS CO.
    00-00-0B          MATRIX CORPORATION
    00-00-0C          CISCO SYSTEMS, INC.
  </code></pre>
  
  <p>I hope you can help me.</p>