Thread: data cut off
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sam Hodo Sam Hodo is offline
external usenet poster
 
Posts: 13
Default data cut off

NickHK

Dim MyString As String
Open "c:\test\book3.txt" For Input As #1 ' Open file for input.
Do While Not EOF(1) ' Loop until end of file.
Input #1, MyString ' Read data

"NickHK" wrote:

Sam,
I bit more info on how you are reading this stream would help.

NickHK

"Sam Hodo" ...
Hello;

I have a data stream that I am reading from a .txt file.
I am trying to write code that will allow me to find an exact match in
several files.

I have a line of data that is getting cut off.
CAP, AIR STEM ASSEMBLY

When I check the search string is CAP
the comma, I think is a cut character for parseing.
How do I get around this.. and keep the search/find string entact.

I open the file the standard way...
open filename as input #1
input #1 mystring

I am new to coding, so examples will be very helpful...

I am running
VB 6.3
office 2003
XP