#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    2
    Rep Power
    0

    remove suburb from address string matching a list


    Hello everyone,
    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.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    3
    Rep Power
    0
    I believe you can use either .SubString(#,#) or .Remove (#,#)
    Something like that...
    R

IMN logo majestic logo threadwatch logo seochat tools logo