Table of Contents
Address
This group of functions allow you to perform various actions to improve the quality of Address data.
Congruence
Check if a country aligns with an email address, telephone number or a URL. E.g.
Country to Email
Input a country with an email and identify whether they align.
| Country | Code | Details | |
|---|---|---|---|
| example@microsoft.co.uk | GB | 1 | TRUE |
| example@microsoft.us | GB | 0 | FALSE |
| example@microsoft.org | GB | 2 | Unknown |
Country to Phone
Input a country with a telephone number and identify whether they align. E.g.
| Country | Code | Details | |
|---|---|---|---|
| 44751 1111 111 | GB | 1 | TRUE |
| 11111 1111 111 | GB | 0 | FALSE |
| 47511 1111 111 | GB | 0 | FALSE |
Country to URL
Input a country with a URL and identify whether they align. E.g.
| URL | Country | Code | Details |
|---|---|---|---|
| google.co.uk | GB | 1 | TRUE |
| google.com | GB | 2 | Unknown |
| google.co.uk | US | 0 | FALSE |
Derive Country
Derive the country name, congruency to a country, ISO 2, ISO 3 and dialling code from a set of input data including Email Address, URL, Telephone Number, Country and City. E.g.
Input
| URL Address | Phone | Country | City | |
|---|---|---|---|---|
| example@google.com | microsoft.com | 0344 800 2400 | US | Redmond |
| example@microsoft.com | google.com | 6502530000 | US | California |
Output
| Country Name | Congruent To Given Country | Match Certainty | Country Identifier - ISO 2 | Country Identifier - ISO 3 | Dialling Code |
|---|---|---|---|---|---|
| United States Of America | TRUE | 80 | US | USA | 1 |
| United States Of America | TRUE | 80 | US | USA | 1 |
Derive Postcode
Input one or more postcodes alongside a country identifier and find out the state/county it belongs to as well as the longitude and latitude. E.g.
| Postcode | Country Identifier - ISO 2 | County | Latitude | Longitude |
|---|---|---|---|---|
| PO13 9FU | GB | Hampshire | 50.81258193 | -1.194509243 |
| 98052 | US | King | 47.6718 | -122.1232 |
| 94043 | US | Santa Clara | 37.4056 | -122.0775 |
Format Postcode
Input one or more postcodes along with a country identifier and return them in the correct format (if possible).
For example, you can choose to format postcodes to identify misinput characters and remove them. E.g.
| Postcode | Country Identifier - ISO 2 | Formatted Postcode |
|---|---|---|
| P/O1£3 9FU | GB | PO13 9FU |
| PO.13 9F.U | GB | PO13 9FU |
| P-O-1-3-9-F-U | GB | PO13 9FU |
Validate Postcode
Input one or more Postcodes alongside their respective country identifiers and identify whether or not they are valid by scoring them TRUE or FALSE. e.g.
| Postcode | Country Identifier - ISO 2 | Output |
|---|---|---|
| PO13 9FU | GB | TRUE |
| PO.13 9F.U | GB | FALSE |
| P-O-1-3-9-F-U | GB | FALSE |
Verify Address
Check if an address exists in a reference dataset from a third-party provider by inputting the following information. By selecting geocode, additional latitude and longitude information is included.
Input
| Address Line 1 | Address Line 2 | Address Line 3 | Postcode | City | State/Province | Country Identifier - ISO 2 |
|---|---|---|---|---|---|---|
| Merlin House | 4 Meteor Way | Fareham | PO13 9FU | Lee-on-the-Solent | Hampshire | GB |
Output
| DQ Address Line 1 | DQ Address Line 2 | DQ Address Line 3 | DQ Address Line 4 | DQ City | DQ Country District | DQ State/Province | DQ Postcode | DQ Country | DQ Country Identifier - ISO 2 | DQ Country Identifier - ISO 3 | Status | DQ Latitude | DQ Longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Merlin House | 4 Meteor Way | Fareham | N/A | Lee-on-the-Solent | Fareham | Hampshire | PO13 9FU | Untied Kingdom | GB | GBR | 50.81250174995649 | -1.194612196176718 |