Start a new topic

Need regular expression to skip gift amount NOT equal to $0

Greetings all,

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?

Thanks!


1 person has this question

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.


(^\d*\.?\d*[1-9]+\d*$)|(^[1-9]+\.?\d*$)

Login to post a comment