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:
“The point is, ladies and gentlemen, that greed, for lack of a better word, is good. Greed is right. Greed works. Greed clarifies, cuts through, and captures the essence of the evolutionary spirit.”
—Stanley Weiser, U.S. screenwriter, and Oliver Stone. Gordon Gekko (Michael Douglas)
“Poverty is relative, and the lack of food and of the necessities of life is not necessarily a hardship. Spiritual and social ostracism, the invasion of your privacy, are what constitute the pain of poverty.”
—Alice Foote MacDougall (18671945)
“If a hermit lives in a state of ecstasy, his lack of comfort becomes the height of comfort. He must relinquish it.”
—Jean Cocteau (18891963)
“Error is a supposition that pleasure and pain, that intelligence, substance, life, are existent in matter. Error is neither Mind nor one of Minds faculties. Error is the contradiction of Truth. Error is a belief without understanding. Error is unreal because untrue. It is that which seemeth to be and is not. If error were true, its truth would be error, and we should have a self-evident absurditynamely, erroneous truth. Thus we should continue to lose the standard of Truth.”
—Mary Baker Eddy (18211910)