delimeter counting: seperating the street from the adresnumber

[Thomas van den Berg]

how can I count the number of blank-seperated word groups in a single field.
The format I receive is aaa (aaa aaa )n(nnn).
aaa can be any number of words, any length. The n(nnn) is not fixed length
either.
The only thing I can think of is a mumps solution: count the number of
space-delemitered words, the last "word" is the streetnumber, the rest is
the street name.

glad for help.


2B Project services
Th. van den Berg RI
Herautstraat 61
8043 AE Zwolle
Nederland
tel : 038-4605619
fax : 038-4605618

https://www.2b.nl

KvK : 38023654
OB nr : nl66245588b01

[Tom van Stiphout]

Re: delimeter counting: seperating the street from the adresnumber

On Mon, 29 Dec 2003 01:14:46 +0100, "Thomas van den Berg"
<vandenberg@2b. nl> wrote:

You could use the Split function, and then check the UBound of the
resulting array.

-Tom.

[color=blue]
>how can I count the number of blank-seperated word groups in a single field.
>The format I receive is aaa (aaa aaa )n(nnn).
>aaa can be any number of words, any length. The n(nnn) is not fixed length
>either.
>The only thing I can think of is a mumps solution: count the number of
>space-delemitered words, the last "word" is the streetnumber, the rest is
>the street name.
>
>glad for help.
>
>
>2B Project services
>Th. van den Berg RI
>Herautstraat 61
>8043 AE Zwolle
>Nederland
>tel : 038-4605619
>fax : 038-4605618
>www.2b.nl
>KvK : 38023654
>OB nr : nl66245588b01
>[/color]

[Th, van den Berg]

Re: delimeter counting: seperating the street from the adresnumber

Ik heb windows XP Pro, en office XP Pro. Het commando Split zie ik niet.
Kunt u een andere functie naam geven.

hoe ziet het commando er uit
t1:split("straa t 15")
t2:???



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Tom van Stiphout]

Re: delimeter counting: seperating the street from the adresnumber

On 29 Dec 2003 01:19:44 GMT, Th, van den Berg <mail@2b.nl> wrote:

Put a bit more effort in it. Split is found in the Help file.
-Tom.

[color=blue]
>Ik heb windows XP Pro, en office XP Pro. Het commando Split zie ik niet.
>Kunt u een andere functie naam geven.
>
>hoe ziet het commando er uit
>t1:split("stra at 15")
>t2:???
>
>
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it![/color]

[Th, van den Berg]

Re: delimeter counting: seperating the street from the adresnumber

My excuses Tom, but I am in this game some time/ I do not ask quicly/
I use the dutch version, i looked through all the help items and I found
"splitsen" which is the dutch equivalent of "split". But it mentions
splitting databases not fields.
Ubound I found.
Thanks for corresponding so quickly.

Th. van den Berg
Herautstraat 61
NL-8043 AE

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Tom van Stiphout]

Re: delimeter counting: seperating the street from the adresnumber

On 29 Dec 2003 08:39:43 GMT, Th, van den Berg <mail@2b.nl> wrote:

Sorry, my bad. Split was introduced with Access 2000, if I'm not
mistaken. You must be on Access 97 or before. In that case, you could
write your own Split function, or find a similar solution using the
InStr function to find spaces. To actually pick the parts apart, you
can use combinations of Left$, Mid$, Right$.

-Tom.

[color=blue]
>My excuses Tom, but I am in this game some time/ I do not ask quicly/
>I use the dutch version, i looked through all the help items and I found
>"splitsen" which is the dutch equivalent of "split". But it mentions
>splitting databases not fields.
>Ubound I found.
>Thanks for corresponding so quickly.
>
>Th. van den Berg
>Herautstraat 61
>NL-8043 AE
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it![/color]

[Larry Linson]

Re: delimeter counting: seperating the street from the adresnumber

"Tom van Stiphout" wrote
[color=blue]
> Sorry, my bad. Split was introduced
> with Access 2000, if I'm not mistaken.
> You must be on Access 97 or before.
> In that case, you could write your own
> Split function, or find a similar solution
> using the InStr function to find spaces.
> To actually pick the parts apart, you
> can use combinations of Left$, Mid$,
> Right$.[/color]

And, searching at http://groups.google.com might very well lead to a Split
function that can just be copied and used. I remember that Joe Foster had
one for Access 2.0 that he called "detokenize ". I don't think he has a
website now with code on it, but there might be a copy in the newsgroup
archive. I'm sure there will be some others, too.

Larry Linson
Microsoft Access MVP

[Douglas J. Steele]

Re: delimeter counting: seperating the street from the adresnumber

"Larry Linson" <bouncer@localh ost.not> wrote in message
news:Bd_Hb.7916 $f3.7251@nwrddc 01.gnilink.net. ..[color=blue]
> "Tom van Stiphout" wrote
>[color=green]
> > Sorry, my bad. Split was introduced
> > with Access 2000, if I'm not mistaken.
> > You must be on Access 97 or before.
> > In that case, you could write your own
> > Split function, or find a similar solution
> > using the InStr function to find spaces.
> > To actually pick the parts apart, you
> > can use combinations of Left$, Mid$,
> > Right$.[/color]
>
> And, searching at http://groups.google.com might very well lead to a Split
> function that can just be copied and used. I remember that Joe Foster had
> one for Access 2.0 that he called "detokenize ". I don't think he has a
> website now with code on it, but there might be a copy in the newsgroup
> archive. I'm sure there will be some others, too.[/color]

If you can't find Joe's, http://support.microsoft.com/?id=188007 contains
sample functions (although they're poorly written)

--
Doug Steele, Microsoft Access MVP

http://I.Am/DougSteele

(No private e-mails, please)

[rkc]

Re: delimeter counting: seperating the street from the adresnumber


"Larry Linson" <bouncer@localh ost.not> wrote in message
news:Bd_Hb.7916 $f3.7251@nwrddc 01.gnilink.net. ..[color=blue]
> And, searching at http://groups.google.com might very well lead to a Split
> function that can just be copied and used. I remember that Joe Foster had
> one for Access 2.0 that he called "detokenize ". I don't think he has a
> website now with code on it, but there might be a copy in the newsgroup
> archive. I'm sure there will be some others, too.[/color]

Everybody and their Uncle Bob has posted a Split function, including
one by Ken Getz.