Export to CSV
From ECHSA Congenital Database
Revision as of 15:18, 4 November 2005 by MaciejBlizinski (talk | contribs)
A CSV file is a text file, with fields delimited with comma "," or semicolon ";". Other delimiters are also allowed, but rarely used. The text fields can be quoted, most often by the double quote mark. The example CSV file would look like this:
hospital_code,ID,First name,Last name ABC,1,John,Doe ABC,2,Mary Jane,Smith
After reading this file in spreadsheet application like OpenOffice or MS Excel, you would get something like:
| Hospital code | ID | First name | Last name |
|---|---|---|---|
| ABC | 1 | John | Doe |
| ABC | 2 | Mary Jane | Smith |
Table linking
The three main tables: patient, admission and operation are linked like this:
