Theramirez
IS-IT--Management
I would like to search for a value in a comma separated textfile. Could someone tell me how to do it ? ...
Thx.
Thx.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how do i search for a value in a textfile
- Thread starter Theramirez
- Start date
- Status
JohnYingling
Programmer
Read each record and use the Instr function.
Code:
Dim I
I = Instr(1,strRecord,strToFind, 0) ' 0=Case Sensitive, 1=Not
If I > 0 then
....found logic
End if- Thread starter
- #3
Theramirez
IS-IT--Management
Thx but reading all the records is what i wanted to avoid ... it's a find like vb for application that's used in word or excel that i had in mind.
thx anyway
thx anyway
JohnYingling
Programmer
They read the text. You would have to create ax index of every possible value to skip text.
- Thread starter
- #5
Theramirez
IS-IT--Management
it where only 1000 records ... i did it your way .. it's not to slow.
thx
thx
- Status
Similar threads
- Locked
- Question