Monday June 26, 2017 Ascolteo logo Databases
& Web

Postal address normalization

French addresses

Normalizing your postal addresses gives you access to the cheapest postage rates offered by the French postal service La Poste. A few cents spared on each letter mean substantial cost savings when you send tens or hundreds of thousands letters.

To take advantage of these reduced postage rates, you must ensure that your addresses comply with La Poste requirements. For example, city and street names have to be spelt according to their reference database.

The use of postal databases in your software leads to faster data entry, easier duplicates removal and reduced returned mail. We advise you to normalize addresses at the time they are entered in the database, in order to avoid subsequent processing costs.

International addresses

Many other countries maintain databases similar to those used in France. A first step may consist in validating the structure of postal codes in your files. Here is a table of regular expressions which permit the validation of the structure of the postal code according to the country. The country codes used in the table are from the ISO 3166-1-alpha-2 standard. Regular expressions comply with the PCRE library.

CodeCountryExpression
DZAlgeria\d{5}
ARArgentina[A-Z]\d{4}[A-Z]{3}
AMArmenia\d{4}
ATAustria\d{4}
AZAzerbaijan\d{4}
BYBelarus\d{6}
BEBelgium\d{4}
BRBrazil\d{5}-\d{3}
BGBulgaria\d{4}
CACanada[A-Z]\d[A-Z] \d[A-Z]\d
CNChina\d{6}
CZCzech Republic\d{3} \d{2}
EEEstonia\d{5}
FIFinland\d{5}
FRFrance\d{5}
DEGermany\d{5}
HUHungary\d{4}
ISIceland\d{3}
INIndia\d{6}
IDIndonesia\d{5}
ILIsrael\d{5}
ITItaly\d{5}
JPJapan\d{3}-\d{4}
KZKazakhstan\d{6}
KGKyrgyzstan\d{6}
LVLatvia\d{4}
LTLithuania\d{5}
LULuxembourg\d{4}
MGMadagascar\d{3}
MXMexico\d{5}
MDMoldova\d{4}
MCMonaco\d{5}
MAMorocco\d{5}
NLNetherlands\d{4}
PKPakistan\d{5}
PHPhilippines\d{4}
PLPoland\d{2}-\d{3}
PTPortugal\d{4}-\d{3}
RORomania\d{6}
RURussian Federation\d{6}
RSSerbia\d{5}
ESSpain\d{5}
CHSwitzerland\d{4}
THThailand\d{5}
TNTunisia\d{4}
TRTurkey\d{5}
UAUkraine\d{5}
GBUnited Kingdom[A-Z]{1,2}\d[\dA-Z]? \d[A-Z]{2}
USUnited States\d{5}
UZUzbekistan\d{6}

Download this list (CSV, 1 kb)

Updated on 28/05/2011


Version française Mobile version
Shortcuts
© 2007-2012 Ascolteo - All rights reserved