title: Remove Line If Value In Column Matches Value In A Separate List
body: <p>I have one file like this:</p>
  
  <pre><code>george@mail.com|george|Sutherland|Manchester|England
  marcel@email.com|Marcel|ZIDANE|Marseille|France
  some@gmail.com|Simon|surname|Somewhere|Else
  </code></pre>
  
  <p>And a list of emails:</p>
  
  <pre><code>ty230923@hotmail.com
  marcel@email.com
  email@anothermail.com
  </code></pre>
  
  <p>I would like to remove all lines from file 1 which contain an email in the first column found in file 2. Expected output would be as follows:</p>
  
  <pre><code>george@mail.com|george|Sutherland|Manchester|England
  some@gmail.com|Simon|surname|Somewhere|Else
  </code></pre>
  
  <p>I need a solution that will work at a large scale (100,000,000's of lines). Have tried a grep solution but after hours of running there was still no result. Have been advised that AWK might be the way to go.</p>
  
  <p>Thanks in advance for any help.</p>