title: Issues with comma delimiter and number of columns when reading in csv file in C#
body: <p>I'm a fairly new coder, and everything I'm working on I have completely taught myself. I'm trying to read in CSV files and then eventually output them to an SQL server. I read a lot about how to do this and decided to implement it using the FileHelpers in Visual Studio 2015. </p>
  
  <p>An issue that I'm running into is that some of the data itself contain commas (ex: 9,500). I know many people suggest putting quotes around the number. However, I am not the one inputting the numbers. The file is just sent to me that way, and I am supposed to write the code to input it into an SQL server. <strong>Is there any other way to fix that issue other than quotation marks?</strong> Also, some of my rows are shorter than others.</p>
  
  <pre><code>ex: Joe, John, Jim, Ben
      35,  42,   35,  60
      A,   B,     C,  D
      40,  50
  </code></pre>
  
  <p>So for example, that last row does not have the same amount of values. They are not null either. I have already addressed null values. </p>
  
  <p>It just doesn't include them, and when I go running my code, I get an error-</p>
  
  <blockquote>
    <p>" Line: 29 Column: 4. Delimiter ',' not found</p>
  </blockquote>
  
  <p>after field 'Hours' (the record has fewer fields, the delimiter is wrong, or the next field must be marked as optional)." </p>
  
  <p>How would I go about fixing these issues? When I remove the rows containing comma values such as 9,500 and when I also remove the incomplete rows, my code works perfectly. However, I need it to work for all of the data. Thanks</p>