title: Empty cell values in CSV files
body: <p>Generally when I open CSV file with Notepad it looks like this</p>
  
  <pre><code>    DN3074;29.06.15;;;;AX103;;11,000;
  </code></pre>
  
  <p>But now I have CSV file that looks like this:</p>
  
  <pre><code>    "DN3074";"29.06.15";"";"";"";"AX103";"";"11,000"
  </code></pre>
  
  <p>I have to import the file in a third party software that is ok with <code>;"XXX";</code> (double quotes with data) but can't handle <code>;"";</code> (double quotes without data).</p>
  
  <p>If I open and save the file on my PC with Excel then the empty double quotes disappear (transformed from <code>;"";</code> into <code>;;</code>) and I can't figure the setting that controls that process. I don't know if the file is generated through another software package or directly in Excel.</p>
  
  <p>Is there a setting (Excel, Regional, etc) that handles how empty cells are interpreted in CSV file?</p>