Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Labels- POssible to show data value and data label together? | Charts and Charting in Excel | |||
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) |