[AccessD] Turn a string into an array

Stuart McLachlan stuart at lexacorp.com.pg
Wed Aug 25 18:14:18 CDT 2021


They've been there since Office 2000 :)

I actually wrote my own VBA  Split and Join() functions  for Access 97 to emulate the VB 
functions.   :)

-- 
Stuart

On 25 Aug 2021 at 18:15, Bill Benson wrote:

> I learned about Split only  two or 3 years ago and it was life
> changing.
> 
> On Thu, Aug 19, 2021 at 9:06 PM Rocky Smolin <rockysmolin2 at gmail.com>
> wrote:
> 
> > Arthur. Google the VBA SPLIT function. I think that's exactly what
> > you need. r
> >
> > On Thu, Aug 19, 2021, 5:17 AM Arthur Fuller
> > <fuller.artful at gmail.com> wrote:
> >
> > > Given a comma-delited string such as "123, 456,  789"; how can I
> > > turn it into an array?
> > >
> > > Thanks..
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list