csv

Description

The csv library contains procedures for parsing and formatting of comma-separated values (CSV) as described in RFC 4180. There are several differences with the RFC:

The RFC prescribes CRLF standard network line breaks, but many CSV files have platform-dependent line endings, so this library accepts any sequence of CRs and LFs as a line break.

The format of header lines is exactly like a regular record and the presence of a header can only be determined from the mime type. This library treats all lines as regular records.

The formal grammar specifies that fields can contain only certain US ASCII characters, but the specification of the MIME type allows for other character sets. This library allow all characters in fields, except for the field delimiter character, CRs and LFs in unquoted fields.

According to the RFC, the records all have to have the same length. This library allows variable length records.

The delimiter character is specified by the user and can be a character other than comma, or an SRFI-14 character set.

Library Procedures

<procedure>(csv-record? X) => BOOL</procedure>

Returns #t if the given object is a csv-record, #f otherwise.

<procedure>(list->csv-record LIST) => CSV-RECORD</procedure>

Takes in a list of values and creates a csv-record object.

<procedure>(csv-record->list CSV-RECORD) => LIST</procedure>

Returns the list of values contained in the given csv-record object.

<procedure>(make-parse [DELIMITER]) => PARSER</procedure>

Returns a CSV parsing procedure. Optional argument DELIMITER specifies the field delimiter (comma by default). DELIMITER can be a character, or an SRFI-14 character set. The returned procedure takes in a string and returns a list of the form:

Returns procedures for outputting individual field values, CSV records, and lists of CSV records, where each list is printed on a separate line.

Procedure FORMAT-CELL takes in a value, obtains its string representation via format, and surrounds the string with quotes, if it contains characters that need to be escaped (such as quote characters, the delimiter character, or newlines).

Procedure FORMAT-RECORD takes in a record of type csv-record and returns its string representation, based on the strings produced by FORMAT-CELL and the delimiter character.

Procedure FORMAT-CVS takes in a list of csv-record objects and produces a string representation using FORMAT-RECORD.

Requires

Version History

2.0 Added formatting routines

1.0 Initial Release

License

Copyright 2009 Ivan Raikov and the Okinawa Institute of Science and Technology.

This program is free software: you can redistribute it and/or
modify it under the terms of the GNU General Public License as
published by the Free Software Foundation, either version 3 of the
License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but
WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
General Public License for more details.

A full copy of the GPL license can be found at
<http://www.gnu.org/licenses/>.