Google
 
   
Login
Username:

Password:


Lost Password?

Register now!
Search
Main Menu
top books
Polls
What do you think about php-deluxe.net?
Excellent!
Cool
Hmm..not bad
What the hell is this?
encyclopedia
recommendation
compare webbrowser
Freenet DSL
Who's Online
5 user(s) are online (4 user(s) are browsing encyclopedia)

Members: 0
Guests: 5

more...
browser tip
Unix Befehle
manual of unix befehle
recommendation!
Sponsored
partner

Comma-separated values

The comma-separated values (CSV) file format is a tabular data format that has field (computer science) separated by the comma grapheme and quoted by the double quote character. If a field s value contains a double quote character it is escape character with a pair of double quote characters.

The CSV file format does not require a specific character encoding, byte order or line terminator format.

It is often not required by Software to have fields quoted unless they contain a comma character.

A similar format is tab-separated values, or .tsv Computer file, is a Delimited data format that has fields separated by the tab character. Application support and usage is similar to a comma-separated values file.

=Formal specifications=

While no formal specification for CSV exists, there are several informal documents describing the format ([http://www.catb.org/~esr/writings/taoup/html/ch05s02.html 1], [http://www.ricebridge.com/products/csvman/reference.htm 2], [http://www.edoceo.com/utilis/csv-file-format.php 3] and [http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm 4]). The closest thing to a formal specification is [http://www.ietf.org/rfc/rfc4180.txt RFC 4180].

=MIME type=

There are several informal .

=Example=

Chicane , Love on the Run , Knight Rider , This field contains a comma, but it doesn t matter as the field is quoted Samuel Barber , Adagio for Strings , Classical , This field contains a double quote character, , but it doesn t matter as it is escaped

=Application support=

The CSV file format is a very simple data file format that is supported by almost all . Any programming language that has input/output and string processing functionality will be able to read and write CSV files.

CSV is similar in ubiquity for tabular data as ASCII files are for text data.

=Programming language tools=

=Utilities=

The [http://www.ioplex.com/~miallen/libmba/dl/examples/csvprint.c csvprint] utility will reformat CSV input based on a format string. This can be useful for reordering fields or generating source code or tables as illustrated in the following example:

$ csvprint data.csv { %0, %1, %2, %3 }, { 0xC0000008, 0x00060001, NT_STATUS_INVALID_HANDLE, The handle is invalid. },

=Software Products=

  • [http://www.simx.com/simx/home_converter.htm SiMX TextConverter] for text-to-database conversion provides an easy-to-use GUI for the non-programmer and can be used as an ActiveX object.