CSV comparison

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

CSV comparison

Postby ctammes » Tue Sep 30, 2008 12:30 pm

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: 1671
Joined: Tue Sep 23, 2003 7:37 pm

Postby grigsoft » Tue Sep 30, 2008 1:00 pm

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.


Return to “Compare It! - Suggestions”

Who is online

Users browsing this forum: No registered users and 1 guest