Matching codes to text subject (Text mining maybe)

[MZ900605]

hello guys, i need your help figuring this out, i have this raw data for subjects i need to match them to another Master file that has the name of the subjects.
 

The master data contain the used term for the subject and its definition, so I should add a field in my Raw data that states the term of the subject which relates.

and a third file that has the code of this subject. 

The result should be a file that has the subject name from the raw data, and the related subject term from master data and finally the code that relates to the subject. Thank you very much for ur help guys so far.

Regards.

[Pravallika20]

Hi,

Can you please provide sample input and output files