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:

<record column1='column1Value' column2='column2Value'/>

were as Nodes as columns is:

<record>
  <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.

Filename:		D:\Test Split.txt
Rows:		10,000
Split size:		4

Would output the following files:

D:\Test Split_01.txt		Rows 1 to 2,500
D:\Test Split_02.txt		Rows 2,501 to 5,000
D:\Test Split_03.txt		Rows 5,001 to 7,500
D:\Test Split_04.txt		Rows 7,501 to 10,000

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 as is therefore disabled.

Page last edited on 12/11/2009