Splitting address and house number

[Noto]

Hi all,

I have a lil problem: Basically I have data of a lot of address that I would like store in a database. But I would like to split the house number / name from the first line of address.

eg. 23 madeup street.

So one field would store the "23" and another store "made up street"

This wouldnt be too much of a problem until you take into account of address' like this:

Flat 27 Made up street
Flat 27a Made up street
Kings Cottage Made up street
Kings house 9 Made up street.

Any ideas or help would be greatly appretiated.

Thanks Ernest

 

[Noto]

I had some ideas for rules:

Flat 27 Made up street
Flat 27a Made up street
Kings Cottage Made up street
Kings house 9 Made up street.


For Flat 27 and Flat 27a, could I do something like:

If text string "flat" is found then take the word flat and everything between the two " " spaces. So this would take Flat 27 and Flat 12232a.


Also if there was no number in address line 1 to store it all into the street field. So then I could search for the blank house number fields and fix them manually if needed.


Kinda funny ideas seem to hit you more when you write things down iron to gold....

 

[Noto]

thanks for all the help I should be able to come up with a solution now.