title: awk check if value from a column in file A exists in file B and if not print whole line of file A
body: <p>fileA:</p>
  <pre><code>date;numberX;descX;numberY
  08-03-2021;5618452029952;TEXT;2250630000000
  08-03-2021;5618452029952;TEXT;2250660000000
  08-03-2021;5618452029952;TEXT;2250670000000
  08-03-2021;5618452029952;TEXT;2250700000000
  08-03-2021;5618452029952;TEXT;2250760000000
  </code></pre>
  <p>fileB:</p>
  <pre><code>2250630000000
  2250670000000
  2250700000000
  2250760000000
  </code></pre>
  <p>I want to check if numberY (column 4) from fileA exists in fileB (which just has 1 column no ;), if not then I want the whole line of fileA printed, so not the matches.</p>
  <p>so it should show</p>
  <pre><code>08-03-2021;5618452029952;TEXT;2250660000000
  </code></pre>
  <p>I thought I was close getting this to work with awk but am missing something somewhere.</p>
  <p>Thank you for your answers.</p>
  <p>addon: I started of by seeing if I could find the matches but even that seems to fail:</p>
  <pre><code>awk -F \; 'NR == FNR { a[$0]; next } ($4 in a)' fileB fileA
  </code></pre>
  <p>addon:  added sample file</p>