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.
Controls the separators used in CSV files.
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.
$CSVSEP = ","; $CSVINTSEP = ";"; $CSVQUOTE = '"'; $CSVOPEN = ""; $CSVLINE = "\n";
$CSVQUOTE = "'"; // single quotes
$CSVSEP = "\t"; // tab separated fields
$CSVOPEN = "b"; // for Apple Macintosh
$CSVLINE = "\r"; // for Apple Macintosh