Contact Form Processing Products - for all your needs

FormMail • Form Encryption • Hosted Forms

CSV File Settings

This page documents the CSV File configuration settings in FormMail.

Type Of Setting

CSV File Settings are OPTIONAL settings, which means...

OPTIONAL : you can change these settings if you need to, but the default values are fine for most circumstances.

Précis

Controls the separators used in CSV files.

Description

If you're creating a CSV file (database) on your server, you can choose the field and line separators.

The settings are:

CSVSEP comma separator between fields (columns)
CSVINTSEP the separator for fields (columns) with multiple values (checkboxes, etc.)
CSVQUOTE all fields in the CSV are quoted with this character; default is double quote. You can change it to single quote or leave it empty for no quotes
CSVOPEN set to "b" to force line terminations to be kept as CSVLINE setting below, regardless of operating system. Keep as empty string and leave CSVLINE unchanged, to get text file terminations for your target operating system. (Line feed on UNIX/Linux, carriage-return line feed on Windows).
CSVLINE line termination for CSV files. The default is a single line feed. You can set the value for the operating system on which you'll read the CSV file. If you want to change this value, you must set CSVOPEN = "b".

The defaults below will suit most purposes.

Default Value

$CSVSEP = ",";
$CSVINTSEP = ";";
$CSVQUOTE = '"';
$CSVOPEN = "";
$CSVLINE = "\n";

Examples

$CSVQUOTE = "'";   // single quotes
$CSVSEP = "\t";    // tab separated fields
$CSVOPEN = "b";    // for Apple Macintosh
$CSVLINE = "\r";   // for Apple Macintosh

See Also