CSV comparison
Posted: 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.
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.