Back to Contents Next
!CSVamp
Version 3.01 - 15th November 2006
Ray Favre © 2006
(Freeware, authored with Dr Wimp)
Introduction
!CSvamp is a utility application whose sole purpose is to make it easy to restructure (‘revamp’) CSV/TSV files i.e. ‘comma-(or tab)-separated-variable’ data files.
For example, if you start with a CSV/TSV file containing a number of records, then you can quickly:
- change the order of the fields within each record;
- extract fields, in any order;
- join fields together, with/without inserted text between them;
- add leading/trailing text to a field;
- add quotes around fields;
- add extra fields;
- split any field into two;
- change between ‘comma-separated’ and ‘tab-separated’ formats;
- change the record terminator between line-feed (LF), return (CR), LF+CR and CR+LF;
- choose which input file records will be included in the processing for the output file;
- produce output file as either ‘CSV’ (&dfe) or ‘Text’ (&fff) file-type;
- sort an input file alpabetically (up or down) - with the option to ignore the first record.
In all cases, the original file is left unaltered and the changes are made in a new output-file, saved in the usual way.
Top of page Back to Contents Next