Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 415
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 415
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Labels- POssible to show data value and data label together? kippers Charts and Charting in Excel 1 April 1st 09 01:33 PM
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India Data Entry India Excel Worksheet Functions 1 March 31st 08 12:51 PM
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia Data Entry India Excel Discussion (Misc queries) 0 March 31st 08 12:00 PM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing [email protected] Excel Discussion (Misc queries) 0 March 20th 08 12:45 PM
MULTIPLE DATA - How to insert new data into existing data.... Rodorodo Excel Discussion (Misc queries) 0 December 15th 06 11:50 PM


All times are GMT +1. The time now is 01:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"