Hi everyone,
I have two files:
- 1 CSV file that contains a long list of items (approximately 4 MB)
- 1 XLS file that contains another list of items (much smaller, about 300KB)
I would like to compare these files with each other and see if items from a column in my xls file are also found in the csv file.
The tables do not have similar layouts.
E.g., in column C of my semicolon-separated CSV file is a list of license plates followed by a $ sign (for whatever reason), my XLS file contains just the license plates in column A.
I would like to have some kind of automated task that checks the CSV file for plates found in my XLS file.
I tried to solve this with Beyond Compare - I am a novice user but have read the documentation and watched tutorial videos.
The software always compares the files line by line which is not what I need - I want it to alert me if there is an item in both lists.
I am running Beyond Compare Pro 4.0.7 (Build 19761) on a commercial license at work.
Any ideas would be greatly appreciated.
If you need any other info from me, please let me know.
Thanks,
Julian
I have two files:
- 1 CSV file that contains a long list of items (approximately 4 MB)
- 1 XLS file that contains another list of items (much smaller, about 300KB)
I would like to compare these files with each other and see if items from a column in my xls file are also found in the csv file.
The tables do not have similar layouts.
E.g., in column C of my semicolon-separated CSV file is a list of license plates followed by a $ sign (for whatever reason), my XLS file contains just the license plates in column A.
I would like to have some kind of automated task that checks the CSV file for plates found in my XLS file.
I tried to solve this with Beyond Compare - I am a novice user but have read the documentation and watched tutorial videos.
The software always compares the files line by line which is not what I need - I want it to alert me if there is an item in both lists.
I am running Beyond Compare Pro 4.0.7 (Build 19761) on a commercial license at work.
Any ideas would be greatly appreciated.
If you need any other info from me, please let me know.
Thanks,
Julian
Comment