ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   data cut off (https://www.excelbanter.com/excel-programming/374011-data-cut-off.html)

Sam Hodo

data cut off
 
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


NickHK[_3_]

data cut off
 
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




Sam Hodo

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





NickHK[_3_]

data cut off
 
Try Line Input instead (and Freefile):

Dim MyString As String
Dim FF As Long

FF = FreeFile

Open "C:\Book1.csv" For Input As #FF ' Open file for input.
Do While Not EOF(FF) ' Loop until end of file.
Line Input #FF, MyString ' Read data
Debug.Print MyString
Loop
Close #FF

NickHK

"Sam Hodo" ...
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







Sam Hodo

data cut off
 
Yes... this did the trick... and I thank you so very much...
Sammy.

"NickHK" wrote:

Try Line Input instead (and Freefile):

Dim MyString As String
Dim FF As Long

FF = FreeFile

Open "C:\Book1.csv" For Input As #FF ' Open file for input.
Do While Not EOF(FF) ' Loop until end of file.
Line Input #FF, MyString ' Read data
Debug.Print MyString
Loop
Close #FF

NickHK

"Sam Hodo" ...
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









All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com