|
Posted by cluthz on 05/18/07 18:04
Hi there,
I have a php / mysql application where I have to change the mysql postcode
field from being one field to two fields (for the first page and second part
of the post code).
In the database abuot 80% of fields have been entered in a good format
having a space between the two sections.
I'm going to write a script that will search for this space and divide all
existing postcodes at the the point where this space occurs. Where there is
no space in a postcode field. I'm just going to cut the postcode at the
fourth character. Therefore anything past the fourth character will go into
the second part of the field.
I thought before i go implementing this. Maybe someone has done it already,
or even knows of a webservice or something that exists that will do it with
better accuracy then I can.
A list of all valid postcodes (first part) would be useful for example as I
could compare each postcode to this list.
Any suggestions most welcome.
Thanks in advance
Navigation:
[Reply to this message]
|