[AccessD] Breaking up a text field

Stuart,

Built-in Split function was used.
But it wasn't enough because it strips out delimiter words.
Therefore SplitStr(...) wrapper function was written.

Shamil

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, October 25, 2005 1:58 AM
Subject: Re: [AccessD] Breaking up a text field


> On 24 Oct 2005 at 22:41, Shamil Salakhetdinov wrote:
>
> > Option Compare Text
> > '...
> ....
> >     avar = SplitStr(strTest)
> >     For i = 0 To UBound(avar)
> >         Debug.Print avar(i)
> >     Next i
> >
> ....
> > Public Function SplitStr( _
> >
>
> Or for Access2K and above, use the built in Split() Function
>
>        avar = Split(strTest,"stuff")
>
> -- 
> Stuart
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com