When we initially imported our 140,000 record database the records came in without a space eg.(V0H2H2) even though there was a space in the previous program.  According to Canada Post standards there has to be one.  Does anyone know how to make a global change to force in a space.

Changing every record individually seems extremely labourious. 

Hoping there is a fix for this problem.

You could export all the postal codes to excel or access, perform a split function on the postal code there and then reimport them. I think that would be the simplest way of doing it.

 Other than writing a plug-in that does this for you I am not sure of any other way. The plug-in itself would be very quick to write - a few hours and would do exactly the same thing. You would just select a query of constituents and the plug-in would split the postal code for all addresses on the constituents and then save them.

Let me know if this is something that you would like help with. Feel free to look at my site for other customizations and helpful fixes that I have done for other organizations.

David

My response is like David's.  I'd do an export to excel. Separate and then import back in.  Good luck.