November 29th, 2003, 04:58 PM
remove suburb from address string matching a list
i have entries like "76 GROSVENOR STREET ST KILDA EAST"
and "8 YAWLA STREET MCKINNON" in one column of a database.
my aim is to seperate the suburb from this address string, so it is like "8 YAWLA STREET" and "MCKINNON", where the suburb can be one two or three words. I have all the suburb names in another column and table, so i could match the address string against the suburb list. i have all this data in an access database, and an excel spreadsheet aswell, and im looking for a solution in any way possible.
Thanks for your help.
November 29th, 2003, 05:16 PM
I believe you can use either .SubString(#,#) or .Remove (#,#)
Something like that...