Formatting plain text
Formatting plain text
(OP)
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,
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,





RE: Formatting plain text
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
RE: Formatting plain text
I will try it over the weekend, and let you know how it turns out.
RE: Formatting plain text
Now I am just working on a progress bar for it.
Cheers.