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 |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article