Comma-separated Values - Application Support

Application Support

The CSV file format is very simple and supported by almost all spreadsheets and database management systems. Many programming languages have libraries available that support CSV files. Many implementations support changing the field-separator character and some quoting conventions, although it is safest to use the simplest conventions, to maximize the recipients' chances of handling the data.

Microsoft Excel will open .csv files, but depending on the system's regional settings, it may expect a semicolon as a separator instead of a comma, since in some languages the comma is used as the decimal separator. Also, many regional versions of Excel will not be able to deal with Unicode in CSV. One simple solution when encountering such difficulties is to change the filename extension from .csv to .txt; then opening the file from an already running Excel with the "Open" command.

When pasting text data into Excel, the tab character is used as a separator: If you copy "hellogoodbye" into the clipboard and paste it into Excel, it goes into two cells. "hello,goodbye" pasted into Excel goes into one cell, including the comma.

OpenOffice.org Calc and LibreOffice Calc handle CSV files and pasted text with a Text Import dialog asking the user to manually specify the delimiters, encoding, format of columns, etc.

There are many utility programs on Unix-style systems that can deal with at least some CSV files. Many such utilities have a way to change the delimiter character, but lack support for any other variations (or for Unicode). Some of the useful programs are:

  • column
  • cut
  • paste
  • join
  • sort
  • uniq (-f to skip comparing the first N fields)

Read more about this topic:  Comma-separated Values

Other articles related to "application support, applications, supports, support, application":

Media Foundation - Application Support
... Windows Vista and later release in Windows 7 Windows 8, finds use in media playback applications ... Until now, mainly internal or bundled Windows services and applications are using Media Foundation ... instead of DXVA 1.0 when the video hardware supports WMV9/VC-1 decoding acceleration ...
Multi-monitor - Other Uses - Older Uses - Application Support
... Microsoft Office applications that do not employ the ribbon interface can have the toolbars moved to the second monitor ... Microsoft Visual Studio 2010 supports multiple monitors, with support for multiple document windows and floating tool windows ... Windows 7 introduces improved support for multiple monitors in extended desktop mode as compared to past releases of Microsoft Windows ...
Database Type Examples
... of its DBMS reside remotely, "in the cloud," while its applications are both developed by programmers and later maintained and utilized by (application's) end ... database system is a DBMS which is tightly integrated with an application software that requires access to stored data in a way that the DBMS is “hidden ... Several products exist to support such databases ...

Famous quotes containing the words support and/or application:

    ‘Tis not enough to help the feeble up,
    But to support him after.
    William Shakespeare (1564–1616)

    By an application of the theory of relativity to the taste of readers, to-day in Germany I am called a German man of science, and in England I am represented as a Swiss Jew. If I come to be regarded as a bête noire the descriptions will be reversed, and I shall become a Swiss Jew for the Germans and a German man of science for the English!
    Albert Einstein (1879–1955)