Comma-separated Values - History

History

Comma-separated values is a data format that pre-dates personal computers by more than a decade: the IBM Fortran (level G) compiler under OS/360 supported them in 1967. List-directed ("free form") input/output was defined in FORTRAN 77 (the 77 means 1977). List-directed input used commas and/or spaces for delimiters, so unquoted character strings could not contain commas or spaces.

Comma-separated value lists are easier to type (for example into punched cards) than fixed-column-aligned data, and were less prone to producing incorrect results if a value was punched one column off from its intended location.

The comma separated list (CSL) is a data format originally known as comma-separated values (CSV) in the oldest days of simple computers. In the industry of personal computers (then more commonly known as "Home Computers"), a common use was small businesses generating solicitations using boilerplate form letters and mailing lists.

CSL/CSVs were used for simple databases. Some early software applications, such as word processors, allowed a stream of "variable data" to be merged between two files: a form letter, and a CSL database of names, addresses, and other data fields. Many applications still have this ability.

Comma separated lists were and are used for the interchange of database information between machines of two different architectures. The plain-text character of CSV files largely avoids incompatibilities such as byte-order and word size. The files are largely human-readable, so it is easier to deal with them in the absence of perfect documentation or communication.

Read more about this topic:  Comma-separated Values

Famous quotes containing the word history:

    The history of reform is always identical; it is the comparison of the idea with the fact. Our modes of living are not agreeable to our imagination. We suspect they are unworthy. We arraign our daily employments.
    Ralph Waldo Emerson (1803–1882)

    The history of this country was made largely by people who wanted to be left alone. Those who could not thrive when left to themselves never felt at ease in America.
    Eric Hoffer (1902–1983)

    The basic idea which runs right through modern history and modern liberalism is that the public has got to be marginalized. The general public are viewed as no more than ignorant and meddlesome outsiders, a bewildered herd.
    Noam Chomsky (b. 1928)