StandardizeView()

Summary

Standardizes address strings in a view and writes the results to a table.

Changes

Regex rules and Queens-style numbers options added in Version 6.0/2012.

Syntax

StandardizeView(string view_set, array address_fields, string rules_file, string ID_field, string output_file_type, string output_file, options)

Argument	Contents
view_set	The view or selection set to standardize
address_fields	An array of names of the address fields
rules_file	The path name of the transformation rules file; if null, Maptitude uses the regex rules option, if provided, else the supplied fileCaliper.rul
ID_field	The name of the ID field
output_file_type	The type of output file
output_file	The path name output file

Option	Type	Contents
Queens-style numbers	Boolean	"True" if the input street address has Queens-style numbers (e.g.: 12-345), otherwise "False" (default)
regex rules	Array	Regular expression rules from a "RegEx" object

Notes

The available rules files are:

Element	Description
Caliper.rul	For street addresses in the U.S.
Num_str.rul	For addresses with the street number followed by the street name
Str_Num.rul	For addresses with the street name followed by the street number

The fields in the output file are:

Element	Description
STDNUMBER	Standardized street number; suffix letters are removed
STDNAME	Standardized street name
POSTADDRESS	Items after the street name such as apartment number, floor, building, etc.
STDSTRT1	Standardized street name for first intersection street
STDSTRT2	Standardized street name for second intersection street

Standardized street names have rule-based abbreviations for the prefix direction, type, and suffix direction (if present).
If there are no intersections, STDSTRT1 and STDSTRT2 will not appear. If there are only intersections, STDNUMBER and STDNAME will not appear. POSTADDRESS will appear if an address has items after the street name.
You can use regular expression rules that you specify with a Regex object. To standardize addresses with your own rules, you first create an object of type RegEx and then use it with StandardizeView(), and set rules_file to null. For more information, see "Address Standardization."

Example

// Open customer.dbf in the tutorial folder
StandardizeView(GetView() + "|",{"ADDRESS"}, , "ID" , "FFB", "c:\\temp\\standardized.bin", )
rx = CreateObject("RegEx","{[0-9]+}:(STDNUMBER) {[a-z ]+}:(STDNAME)")
options = null
options.[regex rules] = rx.GetRules()
StandardizeView(view_set,{"ADDRESS"},null,"ID","FFB","c:\\temp\\standardized.bin",options)
// The output file standardized.bin will contain two columns: STDNUMBER and STDNAME.