Hi
I am stuck on a query where I need to clean up the postcode data we have been given by a client. Some postcodes are in the proper format (eg AA1 1AA or A1 1AA or AA11 1AA). But some are in the incorrect format (eg AA11AA or A11AA or AA111AA).
Does anyone know of a way to update all of the postcodes that don't have blank spaces, so that they have the blank space inserted before the 3rd from last character? I am stumped.
Thanks
I am stuck on a query where I need to clean up the postcode data we have been given by a client. Some postcodes are in the proper format (eg AA1 1AA or A1 1AA or AA11 1AA). But some are in the incorrect format (eg AA11AA or A11AA or AA111AA).
Does anyone know of a way to update all of the postcodes that don't have blank spaces, so that they have the blank space inserted before the 3rd from last character? I am stumped.
Thanks