Help:Common-CSV Format: Difference between revisions
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…' |
Added title. |
||
| Line 1: | Line 1: | ||
__NOTITLE__ | |||
{{Page title|CSV Format }} | |||
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 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. | ||
Latest revision as of 19:17, 16 April 2010
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.
