Start a new topic

Dictionary to replace all values other than 0

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?


Hi Stephanie,

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.

Thank you,
Amanda
Omatic Software

Thanks! I was looking at that solution as well but I think I'm trying to do the opposite. I need the dictionary to say if any other value than 0 the replacement value should be "Registration and Gift" What would I use in the value to match on field to say, anything other than zero?
Login or Signup to post a comment