I've been using the Regular Expression: $1 $2 = (^\D\d\D(?=\d\D\d))((?<=^\D\d\D)\d\D\d$) to add a space to Canadian postal codes
but now I need to check for dashes and replace them with spaces. Test data would be "V0V-0V0"
Any suggestions? Thanks much.
However, there is another solution! In the 184.108.40.206 update to ImportOmatic, we added the ability to generate exceptions deliberately. This allows the user to exclude certain rows from an import, so that they may be run through a separate process. You could use this functionality to isolate the Australia addresses and then run them through a separate profile that does not utilize the US zip code dictionary. I wrote a blog explaining the process, which you might find helpful!
Amanda Tetanich, bCRE
Software Trainer | Omatic Software
Does anyone have any tips for International addresses and postal codes? We currently use the dictionary to add the leading zero to postal codes, but I'm looking for a way to exclude addresses with a country other than US. Australian zip codes can only be 4 characters in RE, so when we import Australian addresses, they create exceptions due to the leading zero postal code dictionary.
Any help would be greatly appreciated.