Hello,
my problem and solution which I need are as follows:
PROBLEM STATEMENT:
I have two sets of files.
File 1 is bi-lingual i.e. it is English and another language with the structure:
English=Foreign Language
File 2 is basically new words that I want to add. These are mono-lingual, i.e. only in English and do not contain language 2.
SOLUTION DESIRED:
The solution desired is to find out and store unique words in file 2 which have not been listed in file 1.
EXAMPLE:
FILE 1
John=Jean
Marie=Marie
Teresa=Therese
FILE 2
John
Peter
Teresa
Margaret
The desired output file should have
Peter
Margaret
since John and Teresa are already listed.
Please help. The files are huge: over 98,000 words and using third party tools to identify duplicates is not possible. I have tried to compare columns (Column 1 in file 1 and file 2), but don't know how to set about it. A script or macro would be just great.
With all good wishes for the New Year and many thanks in anticipation,
Dictdoc
my problem and solution which I need are as follows:
PROBLEM STATEMENT:
I have two sets of files.
File 1 is bi-lingual i.e. it is English and another language with the structure:
English=Foreign Language
File 2 is basically new words that I want to add. These are mono-lingual, i.e. only in English and do not contain language 2.
SOLUTION DESIRED:
The solution desired is to find out and store unique words in file 2 which have not been listed in file 1.
EXAMPLE:
FILE 1
John=Jean
Marie=Marie
Teresa=Therese
FILE 2
John
Peter
Teresa
Margaret
The desired output file should have
Peter
Margaret
since John and Teresa are already listed.
Please help. The files are huge: over 98,000 words and using third party tools to identify duplicates is not possible. I have tried to compare columns (Column 1 in file 1 and file 2), but don't know how to set about it. A script or macro would be just great.
With all good wishes for the New Year and many thanks in anticipation,
Dictdoc