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 theater is a baffling business, and a shockingly wasteful one when you consider that people who have proven their worth, who have appeared in or been responsible for successful plays, who have given outstanding performances, can still, in the full tide of their energy, be forced, through lack of opportunity, to sit idle season after season, their enthusiasm, their morale, their very talent dwindling to slow gray death. Of finances we will not even speak; it is too sad a tale.”
—Ilka Chase (1905–1978)
“My first few weeks in America are always miserable, because the tastes I am cursed with are all of a kind that cannot be gratified here, & I am not enough in sympathy with our “gros public” to make up for the lack on the aesthetic side. One’s friends are delightful; but we are none of us Americans, we don’t think or feel as the Americans do, we are the wretched exotics produced in a European glass-house, the most déplacé & useless class on earth!”
—Edith Wharton (1862–1937)
“A dwarf who brings a standard along with him to measure his own size—take my word, is a dwarf in more articles than one.”
—Laurence Sterne (1713–1768)