Restricting Import of Records using Validation
I am trying to selectively import records from a huge comma separated text database file. I want to import only records that fall in a range of numbers. If I use the Validation of Range, it will only ignore updating the field. I want it to ignore the whole record.
Name of the field is MFR MDL CODE. I want to import only those records that are in the range of 7104605...7104624.
If I understand it correctly, the only 2 cases where you can ignore the whole record on an Import, is with Not empty or Validation by Calculation. Incidentally I am not using a script for this since the import file name changes every time.