Open a text file and into an array ??

[Jason]

Can someoneillustra te how I would open a text file that looks something
similar to this:
namea,8888,1234 .99
nameb,8887,1242 .50

and then after opening that file read each one of the values into an
array...namea and 8888 and 1234.99 would be three arrays

thanks

[tomb]

Jason wrote:

Can someoneillustra te how I would open a text file that looks something
similar to this:
namea,8888,123 4.99
nameb,8887,124 2.50

and then after opening that file read each one of the values into an
array...name a and 8888 and 1234.99 would be three arrays

thanks

Actually, it would be one array, with three indeces.

dim sline as string = lineinput(filep ointer)
dim aline as array = split(sline,"," )
Then you would have these values:
aline(0) = namea
aline(1) = 8888
aline(2) = 1234.99

Tom

[Jason]

"tomb" <to**@technetce nter.com> wrote in message news:NJ******** ********@bignew s8.bellsouth.ne t...
Jason wrote:

Can someoneillustra te how I would open a text file that looks something
similar to this:
namea,8888,1234 .99
nameb,8887,1242 .50

and then after opening that file read each one of the values into an
array...namea and 8888 and 1234.99 would be three arrays

thanks
Actually, it would be one array, with three indeces.

dim sline as string = lineinput(filep ointer)
dim aline as array = split(sline,"," )
Then you would have these values:
aline(0) = namea
aline(1) = 8888
aline(2) = 1234.99

Tom
How would I actually open the file?....and then get that file to seperate into the array. Lets say the file name is test.txt
for example I want to store namea as strUser 8888 as dblaccess and 1234.99 as dblaccount

so I would like it to fill an array like this...
info(0).strUser = "namea"
info(0).dblacce ss = 8888
info(0).dblacco unt = 1234.99

and
info(1).strUser = "nameb"
info(1).dblacce ss = 8887
info(1).dblacco unt = 1242.50

and so on until the end of file.

[tomb]

Jason wrote:

"tomb" <to**@technetce nter.com <mailto:to**@te chnetcenter.com >>
wrote in message news:NJ******** ********@bignew s8.bellsouth.ne t...
Jason wrote:

Can someoneillustra te how I would open a text file that looks something
similar to this:
namea,8888,12 34.99
nameb,8887,12 42.50

and then after opening that file read each one of the values into an
array...nam ea and 8888 and 1234.99 would be three arrays

thanks

Actually, it would be one array, with three indeces.

dim sline as string = lineinput(filep ointer)
dim aline as array = split(sline,"," )
Then you would have these values:
aline(0) = namea
aline(1) = 8888
aline(2) = 1234.99

Tom

How would I actually open the file?....and then get that file to
seperate into the array. Lets say the file name is test.txt

for example I want to store namea as strUser 8888 as dblaccess
and 1234.99 as dblaccount

so I would like it to fill an array like this...
info(0).strUser = "namea"
info(0).dblacce ss = 8888
info(0).dblacco unt = 1234.99

and
info(1).strUser = "nameb"
info(1).dblacce ss = 8887
info(1).dblacco unt = 1242.50

and so on until the end of file.

Why do you need it in an array?
I ask only because in order to dimension the array at the start, you
would need to know how many lines of data you have. While you could
keep redimensioning the array with every line you read, that would be a
serious resource hog. You might want to consider putting the data in a
datatable and working with it that way. Or just read and process one
line at a time, as my original illustration would do.

T