[AccessD] Treat string as array

You mean something like Split but with no delimiter?

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Saturday, March 22, 2008 2:58 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Treat string as array

Well yea.  Uhh... sure.   

I thought I was asking a syntax question.

Given strCompanyName Colby Consulting

I need an array of:

C o l b y  C o n s u l t i n g

It is exactly that piece that I do not know how to do elegantly.  Oh
sure I can do the Mid() function N times but that is inelegant.  I
thought perhaps there would be a single SomeKeyWord(strCompanyName) that
would return an array of the characters in the strCompanyName.  I really
don't work with arrays that much and so I am much less godly in that
area.

John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Saturday, March 22, 2008 5:41 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Treat string as array

Forgive me, el maestro de los classes, but I would have thought this a
no-brainer for you. Write a class with some methods that walk the string
accordingly, like Next and Previous (should you need that one) and so
on.
Encapsulate the mechanics of SubStr() and you're there. No?

And here I deemed you a godlike being regarding classes! Turns out you
bleed just like the rest of us. Go figure. I can already see this class,
thanks to your teachings, and those also of Shamil. Init walks the
string, the other guys deal with the resultant array. Granted, Split()
looks for a delimiter, which in this case we do not have, but we can
walk the string instead, no?
After that, it's cheesecake.

A.

On 3/22/08, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> How can I turn a string into an array?  I need to iterate through the 
> characters of a string.
>
> For each char in str
>         dosomething char
> Next char
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com