analyze text file !!!!!!!

hii !

I have a big problem !
i want to read a line from text file and separate the comma ( , ) from the string ! and than i can take only the string that i will find inside of it .

E.g:

the string : " wer,wer,34,56,45

i need only :

wer
wer
34
56
45
into a new parameters .

thanx !

You could do that in two ways, either split the line into an array or replace each , with a linefeed.

Code:

---

YourArray=Split(Yourstring,",")
'or
YourString=Replace(Yourstring,",",vbcrlf)

---

Use line input to input the line from the file

Code:

---

Open file for input as #1
Line input #1,Yourstring
close #1

---