Formatting plain text

[kabluzy]

Hi. I have some data in a text file, and I need some help to format it. The data is not split into lines, but is deliminated by semi-colons. I need to split it into lines after each semi-colon, then read each value so that I can use it in a program.

eg. 123 f507 287; e23 234 453; 453 543 d34; 453 345 345;

If I split the data into lines, it may generate over 5000 lines of code. Any example codes are apprciated.

Cheers,

 

[FrancisL]

Use the split function
Dim MyData() as string
MyData=Split(YourData,";")
Then each element of MyData contains a value
eg
For i = 0 to ubound(MyData)
'do your stuff with MyData(i)
next

 

[kabluzy]

Thanks Francis.
I will try it over the weekend, and let you know how it turns out.

 

[kabluzy]

Ok. Thanks. Eventually got it to work.
Now I am just working on a progress bar for it.

Cheers.