I have an import file with a column for receipt amount. I'm trying to create a dictionary to say, If the receipt amount is 0 then add an attribute of "registration" and if anything other than 0 add an attribute of "Registration and gift." I'm not sure if this is possible.
I've been reading the forums and support but don't see anything to use an if statement with the replacement - only if that value is blank. I can create the dictionary to say if 0 then replace with "registration" but how would I create the option for anything other than 0. Any suggestions?
Check out #21 in this list: http://iom.uservoice.com/knowledgebase/articles/291286-what-are-some-commonly-used-regular-expressions
This looks like the dictionary you're trying to set up.
Let me know if you have any other questions.