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:

    American time has stretched around the world. It has become the dominant tempo of modern history, especially of the history of Europe.
    Harold Rosenberg (1906–1978)

    To a surprising extent the war-lords in shining armour, the apostles of the martial virtues, tend not to die fighting when the time comes. History is full of ignominious getaways by the great and famous.
    George Orwell (1903–1950)

    It takes a great deal of history to produce a little literature.
    Henry James (1843–1916)