title: Escaping quotes and delimiters in CSV files with Excel
body: <p>I try to import a CSV file in Excel, using <code>;</code> as delimiters, but some columns contains
  <code>;</code> and/or quotes.</p>
  
  <p>My problem is : I can use double quotes to ignore the delimiters for a specific string, but if there is a double quote inside the string, it ignores delimiters until the first double quote, but not after.
  I don't know if it's clear, it's not that easy to explain.</p>
  
  <p>I will try to explain with a example :</p>
  
  <p>Suppose I have this string <code>this is a;test</code> : I use double quotes around the string, to ignore the delimiter => It works.</p>
  
  <p>Now if this string contains delimiters AND double quotes : my trick doesn't work anymore. For example if I have the string <code>this; is" a;test</code> : My added double quotes around the string ignore delimiters for the first part (the delimiter in the part <code>this; is</code> is correctly ignored, but since there is a double quote after, Excel doesn't ignore the next delimiter in the <code>a;test</code> part.</p>
  
  <p>I tried my best to be as clear as possible, I hope you'll understand what is the problem.</p>