title: Importing CSV file in Talend - how to set options to match Excel
body: <p>I have a CSV file that I can open in Excel 2012 and it comes in perfectly. When I try to setup the metadata for this CSV file in Talend the fields (columns) are not splitting the same was as Excel splits them. I suspect I am not properly setting the metadata.</p>
  
  <p>The specific issue is that I have a column with string data in it which may contain commas within the string. For example suppose I have a CSV file with three columns: ID, Name and Age which looks like this:</p>
  
  <pre><code>ID,Name,Age
  1,Ralph,34 
  2,Sue,14
  3,"Smith, John", 42
  </code></pre>
  
  <p>When Excel reads this CSV file it looks at the second element of the third row ("Smith, John") as a single token and places it into a cell by itself.</p>
  
  <p>In Talend it trys to break this same token into two since there is a comma within the token. Apparently Excel ignores all delimeters within a quoted string while Talend by default does not.</p>
  
  <p>My question is how to I get Talend to behave the same as Excel?</p>