title: How to import a string from a CSV file with spaces
body: <p>I have a CSV file with lots of rows like the following:</p>
  
  <pre><code>01-01-2013 02:00 AM;4866,78;string1;1;3
  01-01-2013 03:00 AM;4866,78;string2;1;3
  </code></pre>
  
  <p>I want to import it to a table with the following structure:</p>
  
  <pre><code>+---------+---------------------+---------+--------------+
  |  ID     | Data 1              |Data 2   | ... and so on|
  +---------+---------------------+---------+--------------+
  | 1       |01-01-2013 02:00 AM  | 4866,78 | ...          |
  +---------+---------------------+---------+--------------+
  | 2       |01-01-2013 03:00 AM  | 4866,78 | ...          |
  +---------+---------------------+---------+--------------+
  </code></pre>
  
  <p>The structure is set. ID is auto increment. I have the following import options:
  <img src="https://i.stack.imgur.com/SIIgK.png" alt="CSV Import options"></p>
  
  <p>What settings do I need to undertake to get Data 1, without loosing the spaces inbetween?
  Right now I tried
  Spalten getrennt mit: ;
  Spalten eingeschlossen von: 
  Spalten escaped with: 
  Zielen enden auf: auto
  Column names: Data 1, Data2, ...</p>
  
  <p>My result inside the DB looks like this unfortunately:</p>
  
  <pre><code>+---------+-------------------+---------+--------------+
  |  ID     | Data 1            |Data 2   | ... and so on|
  +---------+-------------------+---------+--------------+
  | 1       |01-01-201302:00AM  | 4866,78 | ...          |
  +---------+-------------------+---------+--------------+
  | 2       |01-01-201303:00AM  | 4866,78 | ...          |
  +---------+-------------------+---------+--------------+
  </code></pre>
  
  <p>I lost the intended and needed spaces inside Data 1 Column.</p>