Introduction

Next

Welcome to CSVfix 1.3. If you have any dealings at all with data and databases, then you almost certainly will have to deal with comma-separated values (CSV) data. Unfortunately, the CSV files you are given, or are required to produce, never seem to be in quite the right format for your particular business application. And because of the structure of CSV records, using standard text processing tools like sed, awk and perl is not as simple as it might be.


CSVfix aims to provide a solution to these problems. It is a command-line stream editor specifically designed to deal with CSV data. With it you can, among other things:


Convert fixed format, multi-line, and DSV files to CSV  

Reorder, remove, split and merge fields  

Sort CSV data on different CSV fields  

Convert case, trim leading & trailing spaces  

Search for specific content using regular expressions  

Filter out duplicate data or data on exclusion lists  

Perform sed/perl style editing  

Enrich with data from other sources  

Add sequence numbers, fixed text and file source information  

Split large CSV files into smaller files based on field contents  

Perform arithmetic calculations on individual fields  

Validate CSV data against a collection of validation rules  

Convert between CSV and XML, fixed format, SQL, DSV and plain texr  

Summarise CSV data, producing averages, frequencies etc.  

Check for differences between CSV files.

               

Please also see the Problems & Solutions section for some common problems and their CSVfix solution.. See the Change Log for information on what is new in this release, and the Commands section for a list of all CSVfix commands.


CSVfix is Free Open Source Software, licensed under the MIT License.



Created with the Personal Edition of HelpNDoc: Full featured Help generator