breakdown adresses into separate fields

[David#]

I have a table of about 12,000 addresses containig a Street No, street name
and a suffix (ave, dr, etc). Can I break this into separate fields? (there
are also some two-word street names which, of course, have a space between
the two words.) I need to puul the street # up to the space into a field,
then the suffix following the last space into a field leaving the remaining
street name in a field by itsself). How can I accomplish this feat?? thanx
- d

 

[John W. Vinson]

I have a table of about 12,000 addresses containig a Street No, street name
and a suffix (ave, dr, etc). Can I break this into separate fields? (there
are also some two-word street names which, of course, have a space between
the two words.) I need to puul the street # up to the space into a field,
then the suffix following the last space into a field leaving the remaining
street name in a field by itsself). How can I accomplish this feat?? thanx
- d

With great difficulty.

Not only will you have a variety of street names - I live on Circle, and the
next street is Old Fort Boise - but some addresses will have a street name and
some won't; some "street numbers" may resemble 1612 1/2 or 225 A; some may be
PO Box Numbers; etc.

There are commercial "address cleaning" services. They aren't cheap, for good
reason.

John W. Vinson [MVP]