5 Replies Latest reply: Nov 14, 2014 4:16 PM by swarup malli RSS

    Where not match?

    Matt Maino

      I am importing an excel file that contains a few fields - one of them being zip_code. I would like to only import those rows from the excel file that do not contain a specific set of zip codes and for some reason nothing that I try works.

       

      this is what I have as the where clause:

       

      where not match(ZIP_CODE, 55555,44444,33333,22222);

       

      does anybody know why this is not working? The script re-loads, but the zip codes are still there.

       

      Thanks