Split Single Address Field into Component Parts
From: Ben Johnson (anonymous_at_discussions.microsoft.com)
Date: 04/06/04
- Next message: Marie: "List field names"
- Previous message: Gerald Stanley: "Re: Two subforms - joins in query"
- Next in thread: Ted Allen: "Split Single Address Field into Component Parts"
- Reply: Ted Allen: "Split Single Address Field into Component Parts"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 6 Apr 2004 04:58:05 -0700
Hi,
I'm working on a database for a client. They want the
database improved and the info displayed in a different
format. Short story: at the moment there is one address
field that contains "17 Some Street". I want to, within a
query, split that single field so that I end up with three
fields - as in "StrNumber", "StrName", "StrType".
I've worked out how to strip out the street number using
the Left function, but I can't work out how to do the rest.
Further problem, in case you're really feeling ambitious,
is that some of these address fields also contain
completely different strings, ie. "C/- Some Real Estate" or
"PO Box 99". It'd be great to be able to differentiate,
but I imagine that's a pretty big ask. I don't want to do
it manually because there are over 10000 records in this
table. And the reason I'm using a query is that I'm trying
to rebuild the database a little more efficiently by taking
a single 70-odd field table and splitting it down into more
relevant, related tables.
All help appreciated.
Cheers,
Ben.
- Next message: Marie: "List field names"
- Previous message: Gerald Stanley: "Re: Two subforms - joins in query"
- Next in thread: Ted Allen: "Split Single Address Field into Component Parts"
- Reply: Ted Allen: "Split Single Address Field into Component Parts"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
