We need to build a dictionary to automate the No Valid Address and Send Mail flags based on whether the Address lines are blank or not.
We want to apply this to a Virtual field that copies the Address line
Example for NVA
Replacement Value | Values to Match on
Yes | syntax to determine if address line is blank, we tried (-BLANK-) and is not working
No | syntax to determine if address line is not blank we tried (.*) and is no working either
Thanks for the input! The no-blank works but we still need a expression for blank, because if the address line is blank we want the NVA check box to be a value of Yes.
Do you know what is the expression for blank
You will need to use a Regular Expression (RegEx) for this type of dictionary.
Try using this as your Value To Match On for the YES Replacement Value (check the box to Use Regular Expressions). You will no longer need a "No" Replacement Value, as that's the default for those fields in RE
Value to Match On:
That is a generic "not blank" statement, and it doesn't work in every situation, but it works in most. At the very least, it's a jumping off point. :-)