CSV File Reading Class (Quote enclosed data friendly version)

Category:
Files and Directories
Type:
Classes
Difficulty:
Intermediate

Author: Anonymous

Version Compatibility: Visual Basic 6

More information:
This is a modified version of (http://www.freevbcode.com/ShowCode.Asp?ID=3110) which properly handles cases where the delimiter appears as part of the field data, and the field value is wrapped in quotes. -------------------- Original Comments: -------------------- This class simplifies the extraction of information from comma separated value (CSV) files. Each line in the file is a record. Each field in the file is separated from its neighbor by the separator character. The delimiter is usually a comma. You specify the file name and, optionally, the field separator. The class code opens the file and makes each line and field available to your code. Refer to comments within the code for examples of how to use the class.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: