title: Search column for string, if found/or not add another string to a separate column
body: <p>Hi I am trying to search a very large .txt file for specific strings in one column of the file found in a separate .txt file.</p>
  
  <p>Depending on whether the string is found/or not in the specified column, I would then like to add another string to a separate column.</p>
  
  <p>For example:</p>
  
  <p>Input file:</p>
  
  <pre><code>ID  data    name    Yes_No
  1   225     name1   
  2   245     name2   
  3   355     name3
  4   466     name4
  5   230     name5
  </code></pre>
  
  <p>File2:</p>
  
  <pre><code>ID
  1
  3
  5
  </code></pre>
  
  <p>Desired output:</p>
  
  <pre><code>ID  data    name    Yes_No
  1   225     name1   1
  2   245     name2   0
  3   355     name3   1
  4   466     name4   0
  5   230     name5   1
  </code></pre>
  
  <p>I am hoping this will be straight forward, but I have become stuck! I would greatly appreciate some help.</p>
  
  <p>Thanks                </p>