strings and migration

[madhavr]

hi

i have a question relating to strings

basically i have a table which contains an address column

the problem is that in the address column the way the address is entered is varied as below...

123 goodge street westministerNW3 5TF

123 goodge street westminister NW3 5TF (most of them are like this where the post code is on a new line)

123 goodge street westministerNW35TF

... etc etc think of all the permutations

anyway i want to migrate the column into a mysql table such that the post code is in a seperate column.

is there an easy way for me to extract it out from the address and then insert it into a new column????

thanks