I have a file that contains gifts from our lockbox but also contains people who are coded to be removed from our mailing list. I have been successful importing the gifts while using "skip row" on those with $0 gift amount. However, now I want to use the same file to skip rows with gift amount NOT equal to $0 so I can code the remainder with an appropriate solicit code. Does anyone have a regular expression to Skip Row if gift amount is not equal to $0?
I had a similar question- but for negative gift amounts
try something like this - should work for 0 (ex. 0, 0.0, 0.00) and any negative numbers. Note: just tested a few scenario's hence needs to be more fully tested.