I want to create a dictionary to add a unit to a constituent record based on postal code. I want to have it that if it starts with anything but T, base the unit on the first character, if it starts with T, base it on the first 3 characters.
Postal Code starts with A, unit will be Newfoundland
Postal Code starts with V, unit will be BC
Postal Code starts with T2C, unit will be Calgary
Any help would be appreciated
When I add that code and test it, the result is what I entered, not the replacement value. Am I missing something?
It works now, except that it is keeping the remaining characters and adding it to the end. Any ideas on how to remove them?
Wonderful thank you so much. I had the *, just forgot the period. New to this, so still learning. Appreciate all the help.