String to Array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thanks, Douglas - That's the nudge in the right direction I needed.
I figgered I'd put the string into an array and then just refer to the
characters as (1), (2), etc. This will work. Thanks, again.
Pat.
 
Back
Top