Solved

loading external multdimensional array from a .txt file

Posted on 2009-05-03
2
362 Views
Last Modified: 2012-05-06
how can i display arrays in vbscript from an external txt file (.txt)
assuming the data on the txt file looks like this

houseno streetname surburb
23 James westside
1 street somewhere
0
Comment
Question by:vbsnoob
2 Comments
 
LVL 10

Accepted Solution

by:
TakedaT earned 250 total points
ID: 24293062
Something like this?

I always hated working with dynamic multidimensional arrays.  Not being able to redim the first dimension just makes it annoying.  I usually just go with 2 one dimensional arrays.
Const forReading = 1, forWriting = 2, forAppending = 8

Dim objFSO : Set objFSO = CreateObject("Scripting.FileSystemObject")

Dim arrAddresses()

strAddressFile = "address.txt"
 

Set readAddressFile = objFSO.OpenTextFile(strAddressFile,forReading)
 

i=0

Do while not readAddressFile.AtEndOfStream

	strLine = readAddressFile.ReadLine

	arrLine = split(strLine," ")

	ReDim preserve arrAddresses(2,i)

	arrAddresses(0,i) = arrLine(0)

	arrAddresses(1,i) = arrLine(1)

	arrAddresses(2,i) = arrLine(2)

	strAddresses = strAddresses & vbCrLf & arrAddresses(0,i) & vbTab & arrAddresses(1,i) & vbTab & arrAddresses(2,i)

	i=i+1

Loop
 

MsgBox strAddresses

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I finished a vbscript that I thought I'd share.  It uses a text file with a list of server names to loop through and get various status reports, then writes them all into an Excel file.  Originally it was put together for our Altiris server…
Script to copy or move mouse-selected collection of files plus targets referenced by shortcuts (.lnk) The purpose of this article is to help illuminate the real challenges and options available (where they may exist) for utilizing simple scriptin…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now