Saving files

CSV Easy supports saving in CSV (Comma Separated Values), XML, Fixed Width and CBD (CSV Easy Binary Data set). Choosing Save from the toolbar or File / Save will overwrite the source file. The Save As icon on the toolbar or File > Save as will show the save dialog.

CSV

You choose your save file by typing in the filename box or by clicking the dotted button to popup a file selection dialog.

Specify the Delimiter and Qualifier you require. This will be the same as the source file initially. Then specify your Line Break style, this is only relevant for files moving between different operating systems. Typically windows based files will have a Carriage Return and Line Feed break but a Linux system would more likely have a Line Feed only. A very useful function.

Having Write first row as column header set will tell CSV Easy to write the column names as the first row of your saved file.

Force qualifiers around all cells will enclose each and every cell written out with the qualifier character, including blank cells.

XML

As with CSV's you select the save file by browsing for it or entering the name manually. Format determines the style the data is written to the file. Attributes as columns:

were as Nodes as columns is:

<column1>column1Value</column1>

<column2>column2Value</column2>

</record>

Record ID is the name that will be used to represent each record node in the output file. Suppress blank columns will not write a node or attribute for a given column if there is no data present.

Fixed Width

Once again you select the save file by browsing for it or entering the name manually. Text Mode and Line Break work in exactly the same way as CSV's. The fixed width file is written with each column padded to the largest value plus 1 space character.

CBD

CBD is the internal binary format used by CSV Easy. Saving in this format creates a set of files that can be re-opened as near instant speeds. This is ideal if you can loaded a very large text file and don't wish to wait for the load again.

Splitting

When saving a large text file you may wish to split it up into several smaller files for ease of managing. Ticking Split into will allow you to do just that. Enter the number of files you wish to split into, then when the save is processed it will evenly split the rows into that number of files.

The file name structure used to create the split set is the filename you set with _XX added to the end (and before the extension) where XX is the split number e.g.

Would output the following files:

If the split is not even (and the option is set) an additional split file will be created to store the remainder. If you have opted to Write first row as column header this will be replicated across all split files.

Note: splitting is irrelevant when saving in CBD and is therefore disabled.