Getting postcodes on in the correct format is important not just for postal reasons (or geodemographic profiling, etc), but also for submitting Gift Aid claims to HMRC. Incorrectly spaced postcodes cause exceptions in the online submission process, and mean we have to start all over again, so this will help us save time and make sure are claiming all the Gift Aid we can.
Thank you! :-)
Jeffrey Montgomery
An ImportOmatic user recently suggested adding a function to format UK postal codes, adding a space when necessary. Fortunately, this is easily done using ImportOmatic's Regex Dictionary functionality. This RegEx dictionary should do the trick (if I fully understood Wikipedia's UK postal code entry):
Here is the dictionary export that you can import directly to your own dictionary:
For Canadian addresses, try this in your "Value to match on": ^([A-Z])([0-9])([A-Z])([0-9])([A-Z])([0-9])$