Current Dictionary is: Value to Match on: ^.+$
Replacement Value: 16
I would like the Replacement Value to be 51 if the title field is blank.
Well hello Tina. So good to see a name I recognize :) I am working in IOM again and unfortunately the -- BLANK -- was not successful.
The challenge I am facing is our donation form doesn't require a title to be entered so when our data file is delivered to import, the title field is missing. Which then causes the Primary Salutation to only populate last name with the #16 formatting.
Data may look like this:
Title, fname, lname
Mr, Dennis, Miller
Mrs., Terri, Blakeslee
For the top and bottom records, I would want #16 format and the two middle, I would want #51.