You are here: Processor Library > Audit > GBR Postcode Format Check

GBR Postcode Format Check

The GBR Postcode Format Check processor checks for British postcodes in an attribute, and validates them syntactically, validating that the postcode conforms to a correct format for British postcodes.

Note that GBR Postcode Format Check uses a reference list of regular expressions to check for postcodes in a valid format.

Use

Use the GBR Postcode Format Check processor to validate that British postcodes have been entered correctly.

Note that the GBR Postcode Format Check processor is designed to check that an attribute contains a syntactically correct GBR postcode only. If the attribute contains a valid GBR postcode, and other data, it will fail the check (though leading and trailing whitespace can be ignored using an option).

Similarly, if you use GBR Postcode Format Check on more than one attribute, the check will be passed provided the attributes form a whole, syntactically valid, GBR postcode only. If any other data exists in those attributes, the check will fail.

Note: If you need to check if an attribute contains a valid GBR postcode, even where it is mixed with other data, use Regex Check with the Contains option and the same reference list of regular expressions.

Configuration

Inputs

Any number of attributes that you wish to check for valid GBR postcodes, or multiple attributes that comprise a GBR postcode (for example, if Outcode and Incode are in separate attributes).

Options

Option

Type

Purpose

Default Value

Valid postcode address patterns

Reference Data (Regular Expressions Category)

Provides a list of valid GBR postcode regular expressions

*UK Postcode Regex

Trim leading and trailing spaces

Yes/No

Allows valid postcodes to be detected where there are spaces either side of the postcode

No

Normalize intra-postcode space

Yes/No

Allows valid postcodes to be detected where a varying amount of whitespace may exist between parts of the postcode. Note that the default regular expression used for validation is already tolerant of multiple spaces, so this option does not normally need to be set.

No

Postcode may be split across attributes

Yes/No

Sets whether or not to allow the postcode to be split across attributes (for example, across separate Outcode and Incode attributes)

No

Outputs

Data attributes

None

Flags

Flag attribute

Purpose

Possible Values

GBRPostcodeValid

Indicates which data passes the GBR Postcode Check

Y/N

Publication to Dashboard

A GBR Postcode Format Check's results may be published to the Dashboard.

The following interpretation of results is used by default:

Result

Dashboard Interpretation

Valid

Pass

Invalid

Alert

Execution

Execution Mode

Supported

Batch

Yes

Real time Monitoring

Yes

Real time Response

Yes

Results Browsing

The GBR Postcode Format Check produces a summary view of its results, showing the following statistics:

Statistic

Meaning

Valid records

Records with only a GBR postcode in a valid pattern in one of the checked attributes (or across checked attributes, where splitting of the postcode is allowed)

Invalid records

Records where the data in the checked attribute was not in a valid GBR postcode pattern

Output Filters

The following output filters are available from a GBR Postcode Format Check:

Example

In this example, GBR Postcode Format Check is used to check data in a POSTCODE attribute:

Summary View

Drilldown on Valid Records

Drilldown on Invalid Records

Oracle ® Enterprise Data Quality Help version 9.0
Copyright © 2006,2011 Oracle and/or its affiliates. All rights reserved.