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.
Post your new features ideas and suggestions here.
2 posts • Page 1 of 1
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 email@example.com.
Who is online
Users browsing this forum: No registered users and 1 guest