Hi
I'm having problems with a Tab delimited file. I read it, but Input# puts in a linebreake when there is a comma in the text.
[code]
fileToOpen = Application.GetOpenFilename("Text Files (*.txt), *.txt")
If fileToOpen <> False Then
Dim rowString As String
FileName = fileToOpen
Open FileName For Input As #1
Do While (Not EOF(1))
' Read the file one line at the time
Input #1, rowString
Loop
Close #1
End If
[stop code]
examaple of the file:
New York -> USD -> 10 000
Stockholm -> SEK -> 9 100,5
The result:
New York -> USD -> 10 000
Stockholm -> SEK -> 9 100
5
Can anyone help me with this problem.
Bookmarks