Comma Delimited

Clinical provides for the importing of comma-delimited or CSV (comma-separated values) files. Files of this type are of plain text format and use a comma to delimit the fields in a record and a CR/LF (carriage return - line feed) to separate records. This means that each record must be on a separate line.

If you wish to include commas within the actual text (in the addresses field for example), you will need to place the information in quotes.

Example:

John, Smith, "22 Main St, Demotown", 1234

When importing into Clinical you will need to set the number and order of fields in the file. Clinical's Maintenance Utility provides a facility to do this.