The situation
Collecting address data from different channels, using different systems and over a longer period of time generates addresses in non-uniform structures. Often, the data will also include unnecessary or even incorrect components. At the latest, the real challenge will present itself when you come to compiling the addresses from the different sources and using them for marketing campaigns.
The solution
As a convenient means of supporting you in such situations, we have developed AZ Trim. Your addresses are
formatted according to an uniform standard, giving you an optimum basis for all future maintenance. This structure allows you a quick and easy start to successful data cleaning and maintenance, with lasting results. Standard cases – where the title, first name and surname for a data record are all in one field, or the post code and county are merged together or entered in the wrong order – are automatically corrected by AZ Trim.
Here are some of the features of AZ Trim:
- Standardised formatting
- Deletion of symbols/separators (e.g. #, @, *, _, etc.)
- Replacement of abbreviations (e.g. dept. = department, Ave. = avenue)
- Elimination of extra spaces
- Left or right justification
- Changes to capitalisation
- Standardisation of address components
- Analysis of name, street and county fields
- Pictures or symbols for titles
AZ Trim can be used both in an online dialogue, e.g. on your homepage, and for batch data processing. Individually definable field names, field types and parameters make AZ Trim a versatile tool for structuring your individual data.
AZ Trim’s intelligent country-specific processing ensures a clean and highly precise structure for your international addresses. This then forms the ideal basis for further processing using our other tools, such as address validation and duplicate comparison.
