title: Delete empty lines in csv file
body: <p>I have a file with 4 million of lines, every line ends with the char $, but I mistakenly add a new line  after the the line delimiter while scraping a website, so right now it is looking like this:</p>
  
  <pre><code>fist name, last name, phone, address, postal code, city, region,$
  
  $
  
  fist name, last name, phone, address, postal code, city, region,$
  
  $
  </code></pre>
  
  <p>the new line '$' only shows up of course if I use :set list, but I'm trying to use this file for a bulk insert in mysql and I'm having problems with it now.</p>
  
  <p>I would like to change the file to:</p>
  
  <pre><code>fist name, last name, phone, address, postal code, city, region,$
  
  fist name, last name, phone, address, postal code, city, region,$
  </code></pre>
  
  <p>How can I do this? with sed or awk or even vi ? looked up around and what I found is not really applying to this case.</p>
  
  <p>please don't take in consideration the extra empty line shown above.</p>
  
  <p>Thanks in advance</p>