I need to extract ONLY differences between two CSV (Character Separated Values) files into a 3rd file. For instance,
File1 is an older version of an exported database in CSV with tab separators and one record per line.
File2 is a recent export of the same database into CSV, also with tab separators and one record per line. It has additions, changes and deletions. This file is sorted the same as File1.
Objective: I need to create a 3rd CSV file that contains entire lines (records) of the changes detected in File2. This way, I end up with File3 which represents all the changes from File1 to File2.
So far, I have installed the most recent version of the BeyondCompare ("BC") tool help me with the above scenario and objective.
I understand the entire process, to reach my objective File3 with ONLY changes, is not fully automated.
I'm finding it difficult to find the features or functions in BC to accomplish this.
How can I accomplish these steps? I would appreciate some guidance on which menu items, mouse clicks or keystrokes I need to use to create my objective File3?
Thank you.
File1 is an older version of an exported database in CSV with tab separators and one record per line.
File2 is a recent export of the same database into CSV, also with tab separators and one record per line. It has additions, changes and deletions. This file is sorted the same as File1.
Objective: I need to create a 3rd CSV file that contains entire lines (records) of the changes detected in File2. This way, I end up with File3 which represents all the changes from File1 to File2.
So far, I have installed the most recent version of the BeyondCompare ("BC") tool help me with the above scenario and objective.
I understand the entire process, to reach my objective File3 with ONLY changes, is not fully automated.
I'm finding it difficult to find the features or functions in BC to accomplish this.
How can I accomplish these steps? I would appreciate some guidance on which menu items, mouse clicks or keystrokes I need to use to create my objective File3?
- How do I set a column in both File1 and File2 CSVs to represent the key field?
- Once a key field is set, can I sort all records (lines) in File1 and File2? How?
- How do I enable a filter to view ONLY changes in File2?
- How do I create the File3 (objective of this exercise) to contain ONLY the changes identified in File2?
Thank you.
Comment