Problem reading in text file

[Jonathan Crawford]

Hi

I am importing a text file like this

Open Me.txtImport For Input As #1 ' Open file for input.
Do While Not EOF(1)
Input #1, MyString
do stuff
Loop
Close #1 ' Close file.

However when it one of the fields has "£91,111.00" in it
mystring starts a new line.

I was wondering if there is anyway to force it not to stat a new line unless
it hits a line break

thanks for any help

jc

 

[John Nurick]

Hi Jonathan,

Why are you using Input # and not Line Input # ?