|
-
February 17th, 2004, 06:26 PM
#1
Split/Parse House Number From Address String
Hi Everyone,
I would like to split and parse the house number out of the address field.
Could anyone give me some advice how to split them?
Here are some examples:
=============================================
INPUT
=============================================
301-A BROADWAY DR
3009 BROADWAY DR
31-11-06 BROADWAY DR
33A-27-1 BROADWAY DR
33B-1 BROADWAY DR
4/5 BROADWAY DR
BLOK L32 205 BROADWAY DR 4
BT 19 3429 BROADWAY DR
BT 21-3/4 BROADWAY DR
BT 3 1/2 BROADWAY DR
C1 LOT 1995 BROADWAY DR
LOT 2353-10 BROADWAY DR
=============================================
OUTPUT
=============================================
HOUSE_NO : 301-A
STREET_NAME: BROADWAY DR
HOUSE_NO : 3009
STREET_NAME: BROADWAY DR
HOUSE_NO : 31-11-06
STREET_NAME: BROADWAY DR
HOUSE_NO : 33A-27-1
STREET_NAME: BROADWAY DR
HOUSE_NO : 33B-1
STREET_NAME: BROADWAY DR
HOUSE_NO : 4/5
STREET_NAME: BROADWAY DR
HOUSE_NO : BLOK L32 205
STREET_NAME: BROADWAY DR
HOUSE_NO : BT 19 3429
STREET_NAME: BROADWAY DR
HOUSE_NO : BT 21-3/4
STREET_NAME: BROADWAY DR
HOUSE_NO : BT 3 1/2
STREET_NAME: BROADWAY DR
HOUSE_NO : C1 LOT 1995
STREET_NAME: BROADWAY DR
HOUSE_NO : LOT 2353-10
STREET_NAME: BROADWAY DR
==============================================
Thanks in advance for any help.
William
Last edited by wsee; February 17th, 2004 at 06:56 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
