Page 1 of 1

CSV comparison

Posted: Tue Sep 30, 2008 12:30 pm
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.


Posted: Tue Sep 30, 2008 1:00 pm
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