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

 

 

 

Building numbers - move or parse

GRCTools manual | Index

Purpose: to move house/building numbers from the front to the back of the street address string or vice versa, allowing commas to be added as desired after or before the house number; or to move the house number to a new field.

Example: 27 Wilhelmstrasse becomes Wilhelmstrasse 27 in Germany; rue d’Amiens 27 becomes 27, rue d’Amiens in France.

The process checks the first 10 digits for numeric characters if the house number is being moved from the front; and, because much information can follow house numbers situated at the end of street address strings, all but the first character if the house number is checked when a move is requested from the back. For this reason, the process of moving house numbers from the back can take slightly longer than the process of moving them from the front.

Information required: GRC ToolsTMneeds to know whether to move the data within the street address strings (from front to back or vice versa) or to a new field.

image

If Within Street Address is chosen, GRC ToolsTMasks whether the house number should be moved from the front to the back or vice versa. Check “Accept lookup table formats” if you want to accept the parameters built into GRC ToolsTM, which contain the position of the house number normal for the country you have chosen. You must also specify whether commas should be added after (if the number is being moved to the front of the address string) or before (if the number is being moved to the back of the address string) the house number.

image If the house number structure for a country is complicated, such as for Spanish- or Portuguese-speaking countries, it is better to move the house number to a new field than to move it within the field. This prevents the “shuffling” of data within a field.

image

image Though the option to add commas is allowed for every country for the sake of flexibility, it is incorrect to add commas to the addresses of some countries. Note also that commas are added/removed for numbers moved during this process, but not for house numbers already correctly positioned. Commas can be added to/removed from these numbers using the process Add/Remove Commas.

If To new field is chosen, GRC ToolsTMasks the name of the field to which to move the number, and whether to start the search from the front of the address string or the back. Check “Accept lookup table formats” if you want to accepts the built in GRC ToolsTMparameters, which contain the position of the house number normal for the country you have chosen.

Numbers often contain a suffix, for example bis in 23 bis rue de Paris. You may specify a field to which to move this suffix. If you do not specify a field, the suffix will be moved to the same field as the house number

Furthermore, if moving numbers from the back of a street address, a string may occur after the house number and its suffix, as in this case: Bahnhofstrasse 25 C Zimmer 3. To enable you to print this data out in the correct order after running this process, you may also specify a field to which to move the string after the house number. In this case, the fields would be filled with:

   Bahnhofstrasse
   25 C
   Zimmer 3

If no field is specified, the data after the house number and suffix is retained in the original field.

image

image A street address can contain a whole set of numbers, such as dates. GRC ToolsTMattempts only to identify the house number. Checking from the end of the address which is most likely to contain the house number greatly increases its accuracy.

Addresses in Switzerland have a different format depending on the language region in which the address is situated. It is therefore necessary to specify these preferences per language region, along with the name of the field where the language code (using the process Language Regions - assign) is written and the codes which have been used. (When parameters are assigned on a country-by-country basis, the language region data is asked on the same screen as the other parameters as above).

image