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, lack and/or standard:
“The particular source of frustration of women observing their own self-study and measuring their worth as women by the distance they kept from men necessitated that a distance be kept, and so what vindicated them also poured fuel on the furnace of their rage. One delight presumed another dissatisfaction, but their hatefulness confessed to their own lack of power to please. They hated men because they needed husbands, and they loathed the men they chased away for going.”
—Alexander Theroux (b. 1940)
“I have been amazed by the Anglo-Saxon’s lack of curiosity about the internal lives and emotions of the Negroes, and for that matter, any non-Anglo-Saxon peoples within our borders, above the class of unskilled labor.”
—Zora Neale Hurston (1891–1960)
“There is a certain standard of grace and beauty which consists in a certain relation between our nature, such as it is, weak or strong, and the thing which pleases us. Whatever is formed according to this standard pleases us, be it house, song, discourse, verse, prose, woman, birds, rivers, trees, room, dress, and so on. Whatever is not made according to this standard displeases those who have good taste.”
—Blaise Pascal (1623–1662)