taking apart a string and putting into array

05-24-2004, 05:45 AM

Protoculture Protoculture is offline

Freshman

Join Date: May 2004

Posts: 43

taking apart a string and putting into array

I have the following string stored in a variable called ToPrint

"print1.pdf, print2.pdf, print3.pdf"

I need to grab each item and store it into an array so I have the following array...

MyArray[1] = print1.pdf
MyArray[2] = print2.pdf
MyArray[3] = print3.pdf

How can this be done?

05-24-2004, 05:50 AM

waits77

Senior Contributor

Join Date: May 2003

Posts: 805

Use Split() with "," as the delimiter

05-24-2004, 06:00 AM

doofusboy

Centurion

Join Date: Sep 2003

Posts: 183

Code:

Dim ToPrint As String
Dim MyArray(2) As String
ToPrint = "print1.pdf, print2.pdf, print3.pdf"
For i = 0 To UBound(Split(ToPrint, ","))
    MyArray(i) = Split(ToPrint, ",")(i)
    MsgBox MyArray(i)
Next i

05-24-2004, 07:38 AM

Diurnal

Enthusiast

Retired Leader
* Expert *

Join Date: Apr 2002

Location: Bellevue, WA.

Posts: 3,233

Quote:

Originally Posted by doofusboy

Code:

Dim ToPrint As String
Dim MyArray(2) As String
ToPrint = "print1.pdf, print2.pdf, print3.pdf"
For i = 0 To UBound(Split(ToPrint, ","))
    MyArray(i) = Split(ToPrint, ",")(i)
    MsgBox MyArray(i)
Next i

The split function uses a dynamic array to operate.

Code:

Dim MyArray() As String
MyArray() = Split(ToPrint, ",")
For i = 0 to UBound(MyArray)
  Me.Print MyArray(i)
Next i

05-24-2004, 10:12 AM

doofusboy

Centurion

Join Date: Sep 2003

Posts: 183

Quote:

Originally Posted by Diurnal

The split function uses a dynamic array to operate.

Code:

Dim MyArray() As String
MyArray() = Split(ToPrint, ",")
For i = 0 to UBound(MyArray)
  Me.Print MyArray(i)
Next i

Thanks; knew it was SOMETHING like that!

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Write 2D array to a file	Dolptrmn	File I/O and Registry	4	11-08-2003 07:42 PM
Putting string in alphabetical order	Marcie	General	2	04-13-2003 10:08 PM
Problem with session variables array	Netrunner	Web Programming	2	04-03-2003 05:32 AM
Short Tutorial: Wide String (unicode) API Calls	Riemann	API	0	03-24-2003 07:06 PM
File format problem	kingesk	General	1	09-08-2000 04:52 PM