Options

Access to the options dialog is through the Tools > Options... menu and holds all the global application settings.

General

External viewer sets the viewing tool that will be used when you open any text based external file. View Source File is an example of this. You can leave this at the default or browse for a specific text viewing tool.

Viewing browser is the browser that will be used by reporting.

Regional format this is used when manipulating data such as numerics as different regions have different formats. This will default to your OS regional settings, but you can override it here.

Check for updates automatically will periodically check for updates to the software and notify the user. You can do this manually from the Help > Check for update... menu.

Assign CSV format automatically is used by the open dialog and will try to automatically determine the format of the CSV file.

Folders

This tab determines the locations of various folders used by CSV Easy. It is not recommended that you change these unless you know what you are doing. Temp folder is the folder used for storing temporary files when processing is performed. Reports folder is the location of the data definitions used by the Data Analysis and Random Data Generator.

Loading

Remove surplus qualifiers removes extra qualifier characters surrounding a columns contents.

Go to first warning after load simply navigates to the first row that has a warning on.

Ignore blank rows completely ignores rows that are empty or consisting entirely of whitespace.

Warn about short rows will add a warning to a row if the number of columns found is less than the expected amount.

Substitute blank column names derives a column name when a blank one is encountered in the form of __blank_col_x

Ignore commented rows if a row starts with the # (Hash) character then the entire row is ignored.

Convert escaped characters converts properly escaped characters such as "" to a single " and /" to a single ".

Ignore NULL characters when a cell is loaded from a file if it contains a null characters they will be ignored. This is useful when you have a mixed encoding file and you see some cells with double spacing between letters.

Saving

Write split remainder to additional file if a split save is not even then the remaining rows will be written to an additional file at the end of the split. If this option is omitted the remainder will all go into the last split file.

Additional

The Reset button will set all global settings back to their original defaults.