Post Code improvement

If a UK postcode is listed in format

AB123CD

AB12CD

A12CD

How can I strip this out to a normalised UK format ?

AB12 3CD

AB1 2CD

A1 2CD

Tagged:

Best Answer

Answers

  • Thanks Akshay I will definitely be using that in the future.


    With regards to the Address Validation step I didn't realise that it auto corrected the format so that is good to know however it does seem to be missing a lot. Any ideas ? I have checked some of these against https://www.royalmail.com/find-a-postcode and they seem to be valid.


  • Akshay DavisAkshay Davis Administrator

    The address validation step will try to validate the entire address, so for those blank entries it would have failed to definitively matched against that postcode. This can happen for a number of reasons, for example where the postcode and town or street don't match.

    The last two columns added by default are the summary level to which the record matched. These are described in more detail here: https://www.edq.com/documentation/aperture-data-studio/validate-addresses-step/

    If you want even more granular detail on why a record matched, failed to match or what corrections were made, you can turn on detailed reporting by selecting the detailed results option from the Advanced options in the step

    This will produce more detailed responses. The FullMatchCode column contains the detailed match code from the underlying engine. To interpret the match codes, you need to refer to the Address Match Codes section of the Batch API Guide as well as the Dataset-Specific Information Bits section of the United Kingdom Data Guide


Sign In or Register to comment.