csvdiff 1.0

csvdiff is a perl script to compare/diff two (comma) seperated files with each other.
csvdiff is a perl script to compare/diff two (comma) separated files with each other. The part that is different to standard diff is, that you'll get the number of the record where the difference occurs and the field/column which is different.

The separator can be set to the value you want it to, not just comma. Also you can to provide a third file which contains the columnnames in one(!) line separated by your separator. If you do so, columnnames are shown if a difference is found.

I wrote csvdiff to compare two database unloadfiles, but you can use it for any kind of file which has separators.

Here are some key features of "csvdiff German Docs":

Choosable field separator
If you provide a file containing the fieldnames, csvdiff tells you (by name) in which field a difference occured
Multiple column key
Ignor upper/lower case
Trim leading/tailing spaces
fade out selectet columns for comparision, usefull for columns with timestamps or columns which are not interesting for you
Sort data befor comparing it, this has only effect if for comparision without key(s)
Ignore empty lines while importing data files
Second output format, looks a bit like diff, but with colour

Requirements:

Getopt::Std
Data::Dumper, deactivated just needed for debugging

Usage:

perl csvdiff.pl -a Actual-Result -e Expectedt-Result -s ";" -c Columnames -t -i -k 2

Parameters

Usage: csvdiff.pl

Parameters: -e File1 Expected Result
-a File2 Actual Result
-c File3 Columnames in csv format (in one Line!), optional
-k Keycolumn(s) Keycolumn(s), optional (separatet by the same separator used for data)
count starts with 1, if you want to use multiple keys do like "3,1"
which meens the third and the first colums together are the unique key
-s Separator Fieldseparator, optional (default=,)
-t Trim leading and tailing blanks, optional
-v Print csvdiff version and quit
-g Grade/sort data before comparision, this has only effect when there are no key column
-i Ignor upper and lower case, optional
-f Fade out column(s) for compare, optional
-h Help, optional
-d coloured Output which looks like diff
-D Debug, optional

last updated on:
November 26th, 2007, 5:53 GMT
price:
FREE!
developed by:
Roland Schmitz
homepage:
csvdiff.sourceforge.net
license type:
(FDL) GNU Free Documentation License 
category:
ROOT \ Documentation

FREE!

In a hurry? Add it to your Download Basket!

user rating 17

2.0/5
 

0/5

Add your review!

SUBMIT