title: Foxpro replace with "" not in
body: <p>I hereby seek for a solution. I have one dbf for january and february each. There are two columns named A and B in each dbf, A is a series of number and B is vlookup, and I want to replace the columnB in february with "new" if its values in columnA do not appear in the column A in january, and "old" for vice versa. My code is the following:</p>
  
  <pre><code>REPLACE ALL B WITH "Old"
  REPLACE ALL B WITH "New" FOR A NOT IN (sele A FROM &amp;filejanuary)
  </code></pre>
  
  <p>Thanks.</p>