Address Validation & Cleansing

Mahulima
Mahulima Contributor

@Seamus Kyle

Hi Seamus,

We have a requirement, where we know the Invalid Address and we want to correct the Address.

For Example ,

We have address

Hurtnkatu 2  HYVINKÄÄ  FIN  05820

But actual address is: Hurtankatu 2 HYVINKÄÄ  FIN  05820

So there was some Spelling mistake. Is it Possible to get teh correct Street Address when we pass the misspelled address?

Thanks,

Mahu

Best Answer

  • Seamus Kyle
    Seamus Kyle Experian Contributor
    Answer ✓

    Hi Malu

    Yes, you can use our Address Validation steps to do this. This compares the input address with the relevant reference data for the country and (where it can match) returns the correct version of the address. This will correct spelling mistakes and add in missing information where found.

    I ran the address you posted through Aperture address validation and I got the following output (the first 2 columns are the original input)

    As you can see the street name has been corrected.

    Please let me know if you need more details as to how to do this in Aperture.

Answers