What's new in CSVfix 1.6
Oct 4, 2014
- Added number command to convert formatted numbers to arithmetic values.
- Added write_multi command to write multi-line master/detail records.
- Added -hdr option to allow CSV header record to be specified.
- Added isint, find and round functions to expression language.
- Added -q option to printf command to support quoting of internal double-quotes.
- Added -ec option to validate command to allow for error return value on validation failure.
- Added -me option to flatten command to support master/detail flattening.
- Added -if option to eval command to mitigate problems with the expression language if() function.
- Added -en option to the SQL generation commands to convert empty fields to NULLs.
- Added -k option to join command to retain all join fields on output.
New in CSVfix 1.5 (Jan 18, 2013)
- Added -skip and -pass options to filter command input and output.
- Added ability to specify default options and aliases via configuration files.
- Actual config file in use is displayed if CSVfix is run with no command line parameters.
- Added head and tail commands to display first/last CSV records in file.
- Added -ic option to join command to ignore case of joined fields.
- Added -f option to printf command to specify order.
- Added -s option to asci_table command to add separator after each record.
- The template command now allows expressions in templates.
- Added -fn option to template command to allow for templated output file names.
- Added -f option to shuffle command to allow shuffling of fields.
- Added several new functions for use by expression language.
- The random number generator used by the expression language can be seeded with the -seed option.
- Can now use != as well as for not-equal operator in expression language.
- Output of help now goes to standard output, not standard error.
- Removed the -rin option as the idea behind it was basically wrong.
New in CSVfix 1.4 (Jan 18, 2013)
- Added timestamp command.
- Added call command to call function in external DLL.
- Added money command to do currency formatting.
- Added -rf option to exclude command to allow specifying of fields from end of record.
- Added -d option to eval command to discard input data
- Added -h option to odbc_get command to get column names as CSV header record
- Fixed -s option bug for find and remove commands
- The validate command now supports multiple error reports for the same record.
- Added -rin flag to make use of expressions mixing numbers and strings a bit easier.
- Added -rh flag to sort command to retain header record on output Various updates to the manual.
New in CSVfix 1.3 (Mar 27, 2012)
- Added block command to mark blocks of records
- Added stat command to produce CSV file record/field counts
- Improved error reporting for commands using the expression language
- Many bug fixes