Help:Common-CSV Format

From DirectWiki
Revision as of 20:19, 18 January 2010 by Bob (talk | contribs) (Created page with 'The Comma Separated Variable (CSV) format is a text representation of a data set where the individual columns of data are separated by commas (,). These tables are normally used…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The Comma Separated Variable (CSV) format is a text representation of a data set where the individual columns of data are separated by commas (,). These tables are normally used to export data from one program to be used in another program. The most common use of these files is to import the data exported from IBS into Excell or another similar data-manipulation program.

The CSV file starts with a Header record. This is the first record in the table and it contains the names of the comumns representated in data section. Each field in the Data Row is separated by a Comma (,) and each Data row ends with a Carriage Return/Line Feed (CR/LF) to separate it from the next Data Row.

Text columns are surrounded by Double Quotes (") and numeric fields are not.

Retrieved from "https://wiki.directsystems.online/index.php?title=Help:Common-CSV_Format&oldid=86"