Skip to content

Latest commit

 

History

History
47 lines (32 loc) · 1.54 KB

README.md

File metadata and controls

47 lines (32 loc) · 1.54 KB
Raw

CSVProcessor

A VFP class to process CSV files.

Overview

  • Imports data from CSV files and strings
  • Automatically generates a cursor (or a table in a database)
  • Appends to existing cursor
  • Field mapping and filtering
  • Also accepts headerless CSV files
  • CSV files may have more than 254 columns, and lines more than 8192 characters
  • Reads Memo-like fields, including multiline fields
  • Also detects Integer, Double, Logical, Varchar(), Date, and Datetime data
  • Date and Datetime source data defined by format patterns
  • Binary columns may be hex or base64 encoded in import and export methods
  • Sensitive to UNICODE encodings (LittleEndian, BigEndian, and UTF-8)
  • Exports to CSV files using the same import settings
  • Exports (but does not import) General fields

Using

  • See UNLICENSE.
  • In a project, include csv.prg and its dependencies
  • DO LOCFILE('csv.prg') to put the class in scope
  • Create an object, and use it (see DOCUMENTATION for more info).

Dependencies

  • CSVProcessor depends on the Namer class.

Contributing

  • Test, use, fork, improve.
  • Review, suggest, and comment.

Acknowledgements

  • An initial version of this class benefited from a generous contribution and thoughtful insights of Dmitry Litvak.

To-Do

  • ...

Talk, talk, talk...