Comma-Separated Text format

You can import, convert, and export files in comma-separated text format.

Converting Comma-Separated Text to FileMaker Pro

•Field names are generic (f1, f2, f3, and so on).

•All fields are text fields.

Exporting Comma-Separated Text files

Commas separate field values. Carriage return characters separate records. Quotation marks enclose all field values, except unformatted numbers.

•Carriage return characters in a field export as vertical tab characters.

•Values in repeating fields are separated by the group separator character.

•Only numeric data is exported from number fields. Any non-numeric data such as text or symbols is not included in the exported data.

•Quotation marks (") in a field (not curly quotes) export as double quotation marks ("").