Lack of A Standard
The name "CSV" indicates the use of the comma to separate data fields. Nevertheless, the term "CSV" is widely used to refer a large family of formats, which differ in many ways. For example, many so-called "CSV" files in fact use the tab character instead of comma (such files can be more precisely referred to as "TSV" for tab separated values); some allow or require single or double quotation marks around some or all fields; and some reserve the very first record for a list of field names.
A particular problem is that in some countries, it is very common to write the decimal point as a comma instead of period. For example, pi would be written as 3,14159. This makes the comma a poor choice for field-separator in many locales. Other implementation differences include handling of more commonplace field separators (such as space or semicolon) and newline characters inside text fields.
Such lack of standardization can cause problems for data exchange based on so-called "CSV" files. One solution is to rely on a standard, such as that proposed by RFC 4180. The more common but technically less satisfactory solution is to rely on human intervention: because CSV files are plain text, humans can view and diagnose most common variants using a text editor.
Read more about this topic: Comma-separated Values
Famous quotes containing the words lack of a, lack of, lack and/or standard:
“Once one is caught up into the material world not one person in ten thousand finds the time to form literary taste, to examine the validity of philosophic concepts for himself, or to form what, for lack of a better phrase, I might call the wise and tragic sense of life.”
—F. Scott Fitzgerald (1896–1940)
“A fool may be a dangerous customer, but the fact of his having such a vulnerable top-end turns danger into a first-rate sport; and whatever defects the old administration in Russia had, it must be conceded that it possessed one outstanding virtue—a lack of brains.”
—Vladimir Nabokov (1899–1977)
“As a novelist, I cannot occupy myself with “characters,” or at any rate central ones, who lack panache, in one or another sense, who would be incapable of a major action or a major passion, or who have not a touch of the ambiguity, the ultimate unaccountability, the enlarging mistiness of persons “in history.” History, as more austerely I now know it, is not romantic. But I am.”
—Elizabeth Bowen (1899–1973)
“Gentlemen, those confederate flags and our national standard are what has made this union great. In what other country could a man who fought against you be permitted to serve as judge over you, be permitted to run for reelection and bespeak your suffrage on Tuesday next at the poles.”
—Laurence Stallings (1894–1968)