I have a file with canadian addresses and I need to import the zip codes in a format that reads character reads XXX XXX, canadian zip codes are a series of letter number letter (space) number letter number. Does anyone know of a format to use in Importomatic that would eliminate me going through the data file to change all the canadian zip codes manually?
over 8 years ago
What is the format of the zip codes, as you receive them in your data file?
How it is formatted in the data file determines, in part, what is needed to format it the way you desire.