Re: String to Array
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Tue, 23 Oct 2007 14:25:01 -0400
You'll need to give us a little bit more information about what's going to
be in MyVar and how you need to parse it.
If all you're trying to do is get at specific characters in the string,
there's no need to convert it to an array: you can get at individual
characters in a string using the Mid function, and you can use other string
functions such as Left, Right and InStr in your parsing.
On the other hand, if what's in the string is going to be delimited in some
way, you can use the Split function to break it into an array on the
component parts.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Pat Backowski" <PatBackowski@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9C976E25-C26D-4372-AF82-60EA74B51E13@xxxxxxxxxxxxxxxx
Hi Folks,
I've taken a user input on a form, and assigned it to a variable in the
code, say MyVar. Its a string. I want to redefine, pass to, somehow
make
it an array, so I can parse characters out of it when I make the name of
the
text file I'm ecentually exporting to.
Many Thanks,
Pat Backowski
.
- Follow-Ups:
- Re: String to Array
- From: Pat Backowski
- Re: String to Array
- References:
- String to Array
- From: Pat Backowski
- String to Array
- Prev by Date: Re: Open From From SubForm Help Needed
- Next by Date: Re: *** How to send email via GroupWise
- Previous by thread: String to Array
- Next by thread: Re: String to Array
- Index(es):
Relevant Pages
|