This is the online manual of GRCTools, personal name and address management software.  Click here for details.

 

 

 

Thoroughfare strings - standardise

GRCTools manual | Index

Purpose: to standardize strings indicating thoroughfare types and other address type strings (“Street”, “strasse”, “rue”, “house”, “apartment”, “zone” etc.) within the user-defined field.

image The lookup tables used by GRC ToolsTMfor this process are very large. GRC ToolsTMmay appear to hang for some time at 0% and 100% during processing. This is normal - avoid interrupting the program at these points.

Example:R. de Paris becomes rue de Paris; Kölnstr. becomes Kölnstraße etc.

Information required: For each field chosen, GRC ToolsTMneeds to know whether the data should be written in a standardized form or in full. By default, GRC ToolsTMwrites the data in its long form. However, in some cases a single abbreviation can have more than one long form. For example, ST in English might be an abbreviation of SAINT or STREET; PTE in Dutch might be a normal word ending or the abbreviation of PORTE, and so on. In these cases, all occurrences are standardized to the short form. Thus: 

   SAINT HELENS ST
   GEDEMPTE PORTE

will become 

   ST HELENS ST
   GEDEMPTE PTE

Choosing the option full will retain the long form when it already exists, and leave the short forms untouched when found. Thus: 

   SAINT HELENS ST
   GEDEMPTE PORTE

will become 

   SAINT HELENS ST
   GEDEMPTE PORTE

Standardizewill produce more standardized but less accurate results; full will produce less standardized but more accurate results.

You also need to specify whether the data each field contains is in upper-case or in mixed (upper and lower) case to ensure that the data is correctly replaced.

The option is also provided to change all thoroughfare types within the user-specified field, or only one. For example, if the field contains the Italian address V V Emmanual 12, then changingall occurrences will change this to via via Emmanual 12. Changing only one occurrence will change it correctly to via V Emmanual 12. When One Occurrence Only is chosen, GRC ToolsTMwill stop looking for thoroughfare types once the first is found, even when this thoroughfare type is already correctly written. Thus via V Emmanual 12 will remain unchanged - the V will not be altered. All Occurrences is useful when there is more than one thoroughfare type in a field, e.g. 31 Railroad Terr., 17 High St. When One Occurrence Only is chosen, then you must specify which end of the address string to start searching for the thoroughfare type (or choose Accept lookup table defaults to use the correct searching end for that country). In Italy, for example, thoroughfare types are usually at the front of the address (via V Emmanual), whilst they are at the back for countries like the United Kingdom (High Street). If All Occurrences is chosen, the address end is setting is ignored.

Note that choosing One occurrence only produces more accurate but less standardized data than choosing All occurrences.

image