![]() |
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 |
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 |
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 |
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 |
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