title: Searching for and matching elements across arrays
body: <p>I have two tables. </p>
  
  <p>In one table there are two columns, one has the ID and the other the abstracts of a document about 300-500 words long. There are about 500 rows.</p>
  
  <p>The other table has only one column and >18000 rows. Each cell of that column contains a distinct acronym such as NGF, EPO, TPO etc.</p>
  
  <p>I am interested in a script that will scan each abstract of the table 1 and identify one or more of the acronyms present in it, which are also present in table 2.</p>
  
  <p>Finally the program will create a separate table where the first column contains the content of the first column of the table 1 (i.e. ID) and the acronyms found in the document associated with that ID.</p>
  
  <p>Can some one with expertise in Python, Perl or any other scripting language help?</p>