CSV comparison

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

CSV comparison

Post by ctammes »

Hi,

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.

Chris.

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

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