VBA Beginner
Registered User.
- Local time
- Today, 09:38
- Joined
- Apr 27, 2010
- Messages
- 11
VBA help needed to manipulate UK Postcodes
Hi all,
I'm trying to mainpulate UK postcodes in MS Access (2003 or 2007). What I need is to split UK postcode in to 4 parts, therefore:
SO10 1QW would be: SO 10 1 QW
M6 5RT would be: M 6 5 RT
WC1X 0BH would be: WC 1X 0 BH
M27 8FZ would be: M 27 8 FZ
BR2 8HX would be: BR 2 8 HX
I've managed to get the 1st, 3rd and 4th parts split out by removing either numbers or letters, however the 3rd part is where I'm stuck as it can be both alpha/numerical.
My only thought is to find the 1st numercial character and return all characters from there until the <space>.
Any ideas on how to do this (or any other solution)?
Thanks!!
Glen
Hi all,
I'm trying to mainpulate UK postcodes in MS Access (2003 or 2007). What I need is to split UK postcode in to 4 parts, therefore:
SO10 1QW would be: SO 10 1 QW
M6 5RT would be: M 6 5 RT
WC1X 0BH would be: WC 1X 0 BH
M27 8FZ would be: M 27 8 FZ
BR2 8HX would be: BR 2 8 HX
I've managed to get the 1st, 3rd and 4th parts split out by removing either numbers or letters, however the 3rd part is where I'm stuck as it can be both alpha/numerical.
My only thought is to find the 1st numercial character and return all characters from there until the <space>.
Any ideas on how to do this (or any other solution)?
Thanks!!
Glen
Last edited: