Parsing a sequential file delimited by semicolons 2

[ribsa3]

Hi there

I am having problems finding anything dealing with parsing text beyond standard behavior.

By this, I have a fairly conventional text file - besides the fact that it is semicolon-delimited. I am wondering what to write between..

Open "c:\myfile.sdv" For Input As #1

.. and ..

Close #1

.. to make it fill my arrays with information constrained between semicolons.

A sample line in the file is:

4;2;SQLSERVER:MyDatabase;ACME Inc.;


Does anyone feel like jotting down a little bit of sample code? If you really want to be valiant, I am populating a listbox with - in this case - text represented in the sample by ACME Inc.

Any help would be greatly appreciated!

Kindly,
-B



--------------------------------------------------------------------
Do what you wish, as long as it harms no one. That includes yourself.

 

[fredericofonseca]

Search the forums

http://www.tek-tips.com/threadminder.cfm?spid=222

and

http://www.tek-tips.com/threadminder.cfm?spid=707

for "text file split" and you will find some examples you can adapt to your needs.


Once you have tried some code and if you still have problems come back to us with the code and what you have tried to do so far.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[PHV]

Take a look at the Split function

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ribsa3]

Have yourselves a star!

Putting your two heads together, I got myself a simple, yet great solution

Thanks!



--------------------------------------------------------------------
Do what you wish, as long as it harms no one. That includes yourself.