CSV comparison

Post your new features ideas and suggestions here.
Post Reply
Posts: 1
Joined: Tue Sep 30, 2008 12:23 pm

CSV comparison

Post by ctammes »


I have to compare two CSV files, fields seperated by comma and surrounded by single quote. All fields except a few might have been changed. Records may be in the source, the destination or in both.

I would like to enter a fieldnumber that always stays the same, in both files and have records with the same field on the same line in the screen.

Example: I have a file with id and name. The id changes, the name always stays the same. I would like CompareIt to use the name field as a key and display the records with the same name next to each other and skip records that do not exist in the source or destination file.


Site Admin
Posts: 1673
Joined: Tue Sep 23, 2003 7:37 pm

Post by grigsoft »

There is no built-in ready to use feature to do this, however in most cases it should be possible to extract key word with RegExps. Check Options>Comparison>RegExps, you will need Automatch rule action. If you have no experience with RegExps, I could help you, but I would need few lines as an example. Post it here or send to support@grigsoft.com.

Post Reply