title: Having trouble with parsing a CSV file in ASP
body: <p>I have a CSV file of products that needs to be uploaded to the sites database.
  The CSV is a normal comma delimited file, but the issue I am having is that some of the fields have a comma in the text. Most fields that have the comma in the text are surrounded by quotes so I assume that could be used some how. Below is the current code I have:</p>
  
  <pre><code>set objFile = server.CreateObject ("Scripting.FileSystemObject")
  set objFileTextStream = objFile.OpenTextFile(file)
  
  'skip first line as those are headers
  objFileTextStream.skipLine 
  
  Do While objFileTextStream.AtEndOfStream &lt;&gt; True 
  
  strLine = objFileTextStream.ReadLine
  
  strLinePart = split(strLine,",") 
  
  'Will have code to insert data in to the database here
  
  Loop 
  
  objFileTextStream.Close
  Set objFileTextStream = Nothing
  </code></pre>
  
  <p>Any help would be greatly appreciated...</p>