Complex regular Expression - format inconsistent

[SPrelewicz]

I have a general "Address" field in a text data set. I need to extract from the general address field specific elements, such as "Address 1", Addy2", City", etc..

The problem is the formatting of that field is tough for this. Occassionay, theres a comma after the building number, occassionally there isnt any commas, spacing is also inconsistent. So, here are some examples [UK addresses]

"Philton, Kemnay, Inverurie, Aberdeenshire AB51 5PB"
"12, Morlich Avenue, Ellon, Aberdeenshire AB41 9GJ"
"5, Vaynes Park Brechin Angus DD9 6LA"

The fields I need are (address1, Address2*, City, Region*, Post Code) where *=optional.

Ive tried working backwards, like "Find two blocks of chars separated by a whitespace in $1, etc...but my regex abailites are average. Can anyone offer any advixe?

Thanks you,

Scott

 

[Corwinsw]

Also as I know, this guy is a good friend with his boss and everything finishes happy.

Corwin

 

[fishiface]

I'm with Interface Solutions (hence the handle). We have warehousing in Solihull and sales offices in High Wycombe and Warrington.

If you feel like ferreting, please don't judge me by the website: I specified neither the interface nor the technology behind it (IIS)!

Yours,

fish

["]As soon as we started programming, we found to our surprise that it wasn't as easy to get programs right as we had thought. Debugging had to be discovered. I can remember the exact instant when I realized that a large part of my life from then on was going to be spent in finding mistakes in my own programs.["]
--Maur

 

[TrojanWarBlade]

LOL.
Don't worry Fish, we won't judge you unfairly!
;-)


Trojan.