file input

i am using

Input #f, temp

to get some information out of a comma delimited file. the information is stored like this...


gServer1, 255.255.255.255


first time i do it i get "gServer1" the second time i do it i get "255.255" it always cuts off after the second peroid, any ideas?

Dim MyString1 As String, MyString2 As String, FileNumber As Integer
FileNumber = FreeFile

Open "some local file" For Input As #FileNumber
Do While Not EOF(FileNumber)
Input #1, MyString1, MyString2
Debug.Print MyString1 & " " & MyString2
Loop
Close #FileNumber

I'm guessing you have temp padded to 8 characters,
that would explain this:

"gServer1"
" 255.255"

I would recommend reading the whole file into a string
variable padded with Space$(LOF(FileNum)) and then
splitting 1. at newlines 2. at commas