Hello, I am in need of developing a Regular Expression Dictionary that can handle multiple conditions. Can anyone provide some insight to how to do this?
If Appeal = XXX and Gift Code = XXX, update Package to XXX.
This could be easily handled with the ImportOmatic API module if you happened to know (or know anyone that knows) a little bit of Visual Basic. Omatic does customizations as well, if you prefer to go that route. Barring that, as Wayne mentioned, you might be able to concatenate the Appeal and Gift Code columns into a new column in Excel before importing, then apply a dictionary to that single column.