retrieving data from text file thru visual basic

[vivekgrs]

hi

in the text file iam having the data as mention below.i want 2 retrieve thru vb.

2 34 56 98 245

i want 2 retrive the data individually which is separate by space.

now i can able 2 retrive the first

left(str, (Instr(str,"")) ------ 2

and the last by

Instrrev(str, "") ----------- 245

i cant able 2 retrieve the middle numbers such as 34, 56 , 98.

can anyone give me idea to solve this problem

regards

vivek

[inter7]

You can try with this code:

-----------------------------------------------------------------------------
V = "2 34 56 98 245"
P = 1
SpPos = 1

While SpPos > 0

SpPos = InStr(P, V, Space(1))

If SpPos > 0 Then
RetVal = Mid(V, P, SpPos - P)
Else
RetVal = Mid(V, InStrRev(V, Space(1)) + 1, Len(V) - InStrRev(V, Space(1)) + 1)
End If

P = SpPos + 1

Print RetVal
Wend
-----------------------------------------------------------------------------

This is not the best way to do it ... anyway ... it works.

Bye

Inter7