Created On:  29 June 2012

Problem:

How do I scan a comma-separated record (CSV)?

Resolution:

See the attached file if you have someone supplying data in a comma-separated (CSV) file.  Note that this code provides the skeleton of scanning comma-delimited records, including detecting fields that are enclosed in quotation marks (").  Subsequent conversion of numeric values, embedded quotation marks, and other anomolies you might find in 'real life' are not addressed.